Automatically Create Separate sheets on difference amounts through VBA

[KumarPK]

Dear Experts, Good Morning,

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

I have a morethan 20+ thousand 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

[KumarPK]

Dear experts,

Please anybody help on my request.???

Regards

KumarPK

[spitfireblue]

Hi KumarPK,

You are better off setting these up as Pivot tables rather than macros (see attached example):
Example.xlsx

Good Luck,
Stephen

[KumarPK]

Wow its great stephen ..... you are genious, one question.. I have total 10 sheets, I want to view only particular sheet and Basedata which I am viewing ..

Rest everything I want to hide... is it possible....??

Thanks
KumarPK

[spitfireblue]

You can hide sheets using macros using the following code:
ActiveWorkbook.Sheets("Name").Visible=xlSheetHidden
or make them visible by replacing xlSheetHidden with xlSheetVisible

[KumarPK]

Thanks Stephen... Its working like charm.. God bless you.