Copy certain data in assigned sheet

[rizmomin]

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

[walruseggman]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[rizmomin]

Hello walruseggman:

Works great except need small modification.
Need a small gray line between months data.
SO data will be at say Column D and E and then Thing grey line then then another months data in column G and H and then thin grey line etc

Please let me know if you have any questions.
Thanks.

Riz

[rizmomin]

Hello:

Please refer to attached file.
Adding little flavor, instead of copying to SheetA, B and C, i would little to copy to closed workbook at location which are in cell B21:B23 for Group Name A, B and C and in each of the closed file sheet name is in cell B20.
Let me know if you have any questions.
Thanks.
Riz

[rizmomin]

Hi John:

Code is malfunctioning.
Please refer to attached file.

It needs to clear all contents from column B onwards at the start of the code.
Need to need to copy the values and format of color, etc and NOT THE FORMULA.
Also would need column for formulas as shown in column E,H, K and so on in Sheet1

Can you please confirm.

Let me know if you have any questions.
Thanks.

Please Login or Register  to view this content.

[rizmomin]

Hi John:

Please refer to attached file.
I got working with little modification as below, however it takes long time to complete.
Would appreciate if you can help to change to code to make it faster.

Let me know if you have any questions.
Thanks.

Please Login or Register  to view this content.