Afternoon all,

I have been a lurker and mostly it has solved my issues! However I cannot find a solution to my current problem.

I have a code (below) which copies data from 'Bank' to 'Cash' sheet, based on column headings, if the column header matches it moves the data. The first and the last bit of the code get's the correct names for them to correctly match. If the column headings match, then it copies the data across and pastes it into the 'Cash.' However, If i do this with a second set of bank data in the same workbook it copies over my current data. I need it to paste over to the 'Cash' sheet, but on the next available row. Instead of constantly pasting into the row just below the column headings.....

Any ideas?

Thanks, 

Please Login or Register  to view this content.