Rayne
asked on
VBA Please
There is a large Named Range (“Source”) in a excel file. Need to VBA to do this:
a. Without removing or deleting the named range , add a table to the named range so that it gives some good format to the 30000 rows.
b. Create a pivot table out of that named range’s range in the format shown in ‘pivot’ sheet
Copy-of-pivotV2--VBA.xlsx
a. Without removing or deleting the named range , add a table to the named range so that it gives some good format to the 30000 rows.
b. Create a pivot table out of that named range’s range in the format shown in ‘pivot’ sheet
Copy-of-pivotV2--VBA.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks, Rayne. Glad to help!
ASKER
Hello Brian,
Here is a question if you are interested:
https://www.experts-exchange.com/questions/28016612/Update-Columns-Back-Forth.html?anchorAnswerId=38842989#a38842989
Thanks
Here is a question if you are interested:
https://www.experts-exchange.com/questions/28016612/Update-Columns-Back-Forth.html?anchorAnswerId=38842989#a38842989
Thanks
ASKER
You are awesome :)