Help merge sheets data

pandeec

New member
Joined
Feb 7, 2013
Messages
7
Reaction score
0
Points
0
Hi... I have 5 sheets… Sheet1 has Name list, by use of formula =If(isblank()…. I made name would appear in all other sheets…Now I want in “CONSOLIDATION” Sheet ( 5th sheet) all the datas of other datas would appear in correspondence column… Please download my attachment and give a formula…(If I delete/modify a name in sheet1 the datas of that names would disappear in all other sheets including “CONSOLIDATION” Sheet. Thanks in Advance…
 

Attachments

  • Deep.xlsx
    10.9 KB · Views: 9
Top