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