toony
New member
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.