I want to write VBA code (Not record Macro) that does following:
(1) It copies 5 columns from few worksheets (defined Table Name in each worksheet). It copies this data one below the other. Columns in each worksheet is identical data type. (2) There are blank rows in each table. Remove the blank rows. So, now we will have 1 Master Table
We will have 2 clickable buttons, that will do above 2 things.
Then 3rd button will do Pivot Table from the Master Table noted above.
We can do Screen Share, so that I can clarify this better.
Solved by A. H. in 30 mins