Hi,
My skills with VBA at the moment are pretty basic and I’d like a bit of help to get started writing the code.
I have a report (WBK1.xlsx) with 14 different headers in row 2. They can be named Header1, Header 2 etc. I can change them manually later if needed.
The second spreadsheet (WBK2.xlsx) in my documents folder has the only some of the same headers in row 10. I want to write a macro that will copy the rows with data from WBK1, open WBK2 and then paste to WBK 2 row 12 where the headers match. This is where I fall when using the recorder.
There are two columns called ‘Debit’ and ‘Credit’ where I would like to paste as values.
If someone could help me get a start I would greatly appreciate it.
Thanks,
DB
Bookmarks