Hi Experts,
Am new to VBA and tried to record macro to copy table from pivot table and it worked fine but now I want to do some formatting on the copied table.
Am always copying data from pivot table and copying to cell starting at Range("D23"). I want to merge cells from D25 till row before "Total". I tried recording and its hardcoded. If number of rows increase/decrease it merge cells with hardcoded range. Is it possible to select range till "Total" and merge?
Here is the table how it looks before formatting/merging:
T1.JPG
This is how I want table to look like:
T2.JPG
Also how can I rename "Grand Total" to "Total"
Any help much appreciated.
Thanks,
Richa
Bookmarks