Hi All, Newbie here I'm afraid....
I have a daily task that I want to automate via VBA if possible. I get a daily update to my source file (call it 'Workflow' for now) and the number of records is different every day. I need to copy various columns from my source file to a target (destination) file (Call that 'Capital Review' for now). The source workbook has more columns than the target workbook. They are not in the same format so I have to do it column by column which is pretty time consuming, so was thinking a VBA scripy could possibly do this, but as I don't know how many records I'll get on any given day I don't know how to approach it. I am not an experienced VBA user. Basic issue is as follows:
Source workbook column to Target Workflow column: ALL PASTE VALUES ARE PASTE SPECIAL = VALUES
Col A to Col D (and reformat date to 'short date' format)
Col B to Col E
Col J to Col AA
Col O to Col M
Col P to Col Y
Col R to Col P
Col W to Col K
Col AA to Col Z
Col AB to Col C
Col AC to Col B
Col AP to Col J
Col AT to Col O
Col AU to Col I
Col AV to Col S
I am sure this is possible but don't know where to start. Any tips? Is this possible? Any help gratefully received.
Both Workbooks are usually open, but don't have to be.
Thanks,
Andy
Bookmarks