VBA to paste 2 sets of formatted data into one sheet

**kenadams378** · 12-11-2012, 04:56 AM

Morning,

I have the following code that takes 2 sets of data, formats the data and paste this into one tab of data called 'GI Data'

My issue is when i have written the code, the final part of the code overwrites the 1st part of the code when copying the data into the 'GI Data' tab

I assume i need to use the lastrow or lrow funtion but i'm not sure where to add this to my code

Any help would be appreciated;

Full code;

Please Login or Register  to view this content.

**AB33** · 12-11-2012, 05:26 AM

It is difficult to comment with out seeing the workbook, but try one of these lines.

Please Login or Register  to view this content.

**kenadams378** · 12-11-2012, 05:32 AM

Where in my code shall i add one of those lines?

I have attached a sample if it helps, the data in the attached is the raw data, if you run the code you will see only the C2 data is copied into the GI Data tab.