Hi,
I need to consolidate some of the data (column D,J & K) from other tabs to the first tab.
The macro should copy all non empty cells of column-D till the end and copy the respctive cells of J&K and then paste it to consolidated tab. This activity should be done for all the tabs
It will be great, if you can give the links to the source row also in the consolidated tab
Attaching the file
Macro.xlsx
Bookmarks