On clicking the Submit button pivot table should be generated

[aleanboy]

Hi All,

Please advise how do I get this done through Macro,

I have attached the sheet for your reference.

Raw data is available in Sheet named as "Table for today".
Step 1. From "Table of today" sheet, first two rows & last row has to be deleted.
Step 2. Numbers in text format has to be converted to Number format. Note: I do not want to select and convert, it has to be done automatically ( No problem if entire sheet gets converted to number format)
Step 3. Pivot has to be generated as shown in Sheet 3.

Please advise how to I achieve above 3 steps using macro

Trying to figure this from todays without success.

Thank you in advance.

[tehneXus]

Hi,

put this into a module:

Please Login or Register  to view this content.

Cheers!

[aleanboy]

HI Mate,

it works great.. Once I have the created the pivot created for "Table for today" in sheet3, I would like to put one more pivot table from details available in another sheet named "Database". How can I achieve it ...

Pivot has to be generated in Sheet4

Please advise.

[aleanboy]

Hi ,

Anyone please advise on the above request.....

Thank you in advance..