Keeping rows together after link

[jdavis3874]

I have spreadsheet that has several columns that link to anothe
spreadsheet.This is G1100. My A,B,C,D columns is where I pu
information related to the information in G-P. For instance, G-P link
to a students information. It changes all the time. In A-D I hav
columns to input criteria for each student. The problem is that whe
the link updates the criteria and the student info end up on diffren
rows now. For instance If B1 is " Has Housing" and G1 is " Steve" afte
the update " Steve" might move to G3 and the "Has Housing" does no
move with it

 

[Frank Kabel]

Hi
I don't see a chance to make this work in Excel. Problem is Excel does
not link dfata in different rows together.
You may consider using a reference / unique identifier and use VLOOKUP
to combine the data. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[jdavis3874]

Thanks for the help. I guess I wil have to find another way around