To consolidate selected data from other tabs

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

1) RIght-click the Consolidated tab and select VIEW CODE to open the sheet module
2) Paste in the activation code:

Please Login or Register  to view this content.

3) Save your workbook as a .xlsm file so the macro is preserved.

4) To use the macro simply switch to any other sheet and back the to Consolidated sheet. Every time you "activate" this sheet it will repopulate itself.

You may also try this.....
Place the below code on a Standard Module.

Please Login or Register  to view this content.

Hi,
Thanks for the reply...


I have used the first code, but need some modifications in that if you dont mind.


In that, I want to get it pasted as values... and I wanted a hyper link,(may be like in the example) so that, user can easily go to that particular row, from where the data got copy pasted

And in the current formula, it is selecting a range in the consolidated tab. I would like that to go to 1st cell of the selected range.

Root Cause Analysis.xlsm

Anybody.. please...

Please find the attached sheet and see if this is what you are trying to achieve?

Wow.. this is exactly what i wanted.. thanks for the help

You're welcome. Glad to help.