macros copy paste

  1. D

    Updating multiple table entries by date with VBA

    Hello, New to the forum and so far impressed with the level of support provided to people. I am just starting my journey on VBA and need help with what I think it's an easy macros that I just can't figure out. I need to populate "Table 2" with the past 10 years worth of daily data copied from...
  2. B

    VBA Macro will post formula incorrectly

    Hello everyone. I am using a macro to consolidate two files and have the information referenced between two sheets, but when the macro is supposed to paste a formula {=IFERROR(VLOOKUP(B6,GTN!A:C,2,FALSE),""}, what I end up getting is a different one {=IFERROR(VLOOKUP('B6',GTN!A:M:M,2,FALSE),"")}...
  3. R

    VBA code for copying columns from one worksheet to another when source file is keeps changing

    I have to copy column A, C and D from source file (sheet name"Input") to column A,B and C in destination file (sheet "sections"). But the source file name keeps changing every time new data is recorded. Can i use workbooks(1) and workbooks(2) instead of specifying workbook name if these are the...
  4. P

    How to loop through all pdfs in a folder and copy them to Excel 2016

    Hi, Am an struggling with the following problem. I need to copy pdf sales invoices to Excel 2016, into 1 Sheet, one under the other i.e. all in 1 column. As the amount of documents is big doing it manually is totally counterproductive. I tried to find a suitable piece of VBA Code to do this but...
  5. S

    Copying certain cells in a row when a text is placed in a column

    Greetings, new here and also a newbie to excel but learning my way around. Little background on my excel file (workbook): as of now it consists of 12 sheets all of which are identical for each month and we input information daily tallying certain criteria. There is also a year to date sheet...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top