Code to copy data to another workbook using headers

[dbracken1]

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

[haripopuri]

Please upload workbooks you are referring to. It will be easy working on them for us.

[dbracken1]

Tried again and it let me. I've just put generic data in.

I want to take the data from row 3 wbk1 and paste to row 12 wbk2 where the headers match. Ideally I'd prefer to leave out the lines with Journal1-Journal4 and the totals at the end. the number of rows will change month to month however