|Here's what I'm trying to accomplish in a nutshell...|
I'm taking the list of everyone's name at my command from its respected worksheet by using the following formula for column A:
='[Name of File.xlsx]Master'!$A:A - (So that it auto-populates whenever someone checks-in/out.)
In colums B-I; I am filling in an "X" values in each cell for area's that they completed. (ie. B=Form, C=Certificate, D=Signatures, ect)
However the problem that I'm facing is that whenever someone new comes in or someone leaves, the formula portion shifts column A properly, but the data remains in the same cells to which of course gives the users inaccurate data. Is there a way so that the whole row can shift whenever the formula changes and the data from B-I goes with it?