Hello:
Please refer to attached file.
I have Income data as shown in Sheet1.
I need to seperate out the data based on Group Name assigned in Cell E1,H1,K1,N1 and so on.
Depending on the Group Name I need to copy the data in Sheet A, B and C.
I have manually copied data for Group Name A in SheetA.
Sheet1, Copy D1:F16 at SheetA at D1.
Sheet1, Copy M1:O16 at SheetA at G1....and so on.
Need to make sure that the format stays as is.
Let me know if you have any questions.
Thanks.
Riz
Bookmarks