Dear folks,
i have this worksheet (i attached the file), where i have to combine the data on 3 sheets into one consecuted sheet, so that i can present the data by pivot table.
So, it will go like this : sheet 1 will be the header, so i put the details of sheet 2 and sheet 3 on right on the next of it (which is column E).
The scenario is data on column C on sheet 1 will be check againts data on column A on sheet 2, and then copied back to cell E1 on sheet1. if there are any row exist with the same value on sheet2, it will insert new row and repeat to copy the next data range into E2. and so on..
the same rule applied on the third sheet (sheet3), it will find the same value based on Column C on sheet 2 with Column 1 of sheet 3.
End result would be like on sheet 'after'.
It sound simple, but i'm rookie with this stuff. Please advise how to fix this with macro. i only put some 'detail' row on sheet 2 and sheet 3, with me i have about ten thousands row on each sheet.
Thanks guys
Bookmarks