Automatically Create Separate sheets on difference amounts through VBA

[prasanna]

Dear Experts, Good Morning,

I need help to create 3 types of Variance in amounts ( Consolidation Increase and Decrease) sheet in different sheets Product ID wise on monthly basis entire financial year automatically through VBA.

I have a more than 20000 line items, but i added only few for samples monthly wise.

My humble request to you, Please help me, I am taking huge time to prepare this data through manually.

Sample file uploaded for your persual.

Thanks,

With regards,
KumarPK

 

[Hui]

You may want to consider the techniques discussed in these two posts :

Move Data to other Sheets
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/
Advanced Filter Move Data to other Files
http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/

 

[prasanna]

Hi Hui..

Thanks for reply, I saw the link but I am so confused because I m new to VBA...

This sheet include calculations and create increase and decrease amount from the base file.

Please help and do the needful


Thanks
Prasanna