VBA macro to copy rows based on criteria then insert rows on another sheet and paste

[sfric]

Hello all,

I've searched this forum and can't find a solution for a problem like I have:

In the "Main" sheet I have the following:

Area	Jan	Feb	Mar
Section1	100	75	125
Section2	50	50	75
Section3	25	28	75
Section4	10	100	50

<colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody>
</tbody>

The "Input" sheet contains the following:

Category	Area	Jan	Feb	Mar
Revenue	Section3	50
Expense	Section1	20
Expense	Section2		20
Revenue	Section1		20
Tax	Section4		10
Tax	Section3		15
Revenue	Section2			25

<colgroup><col style="width:48pt" span="5" width="64"> </colgroup><tbody>
</tbody>

After the macro is run I would like the "Main" sheet to look as follows:

Area	Jan	Feb	Mar
Section1	100	75	125
Expense	20	0
Revenue	0	20
Section1 Total	120	95	125
Section2	50	50	75
Expense		20
Revenue			25
Section2 Total	50	70	100
Section3	25	28	75
Tax		15
Section3 Total	25	43	75
Section4	10	100	50
Tax		10
Section4 Total	10	110	50

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

Keep in mind that rows will be added to the input tabs each month and therefore require rows to be appended under each "Section".

Any help would be greatly appreciated.

 

[kevatarvind]

can you upload your data file how it looks i have the solution but need to see your data how looks ?

 

[sfric]

kevatarvind, thanks for your reply, however, my posting permissions do not allow me to post attachments. You can copy and paste the first two tables i provided into different sheets to replicate what i'm trying to do. The third sheet is what the result should look like. Thanks again.