J
jdavis3874
I have spreadsheet that has several columns that link to anothe
spreadsheet.This is G1
100. 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
spreadsheet.This is G1
100. My A,B,C,D columns is where I puinformation 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