copy and paste (only values) macro

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
I need to automate an everyday action, to copy and paste the values of random columns from another worksheet. The headings (don't want to copy paste them) are the same. The copied workbook I populated every day and I require these column values into an annual workbook. So, they have the columns in different order one to another, and the row numbers also differ. I don't know anything about macros and all I did was to press Record Macro (chosed relative references), but when I run it the values are pasted very randomly anywhere. I have attached the VBA code. I would be sooooo grateful if somebody can help me with this.
 

Attachments

  • Sub Macro8.VBA.docx
    13.3 KB · Views: 7
Back
Top