Need to Lock Row Data & Insert/Delete Row based on Formula

August 27, 2013 at 11:50:55
Specs: Windows 7
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?

See More: Need to Lock Row Data & Insert/Delete Row based on Formula

Report •

August 27, 2013 at 12:20:24
I don't understand how the formula "auto-populates whenever someone checks-in/out" or how "the formula portion shifts column A properly".

Could you explain how you are using that formula in a little more detail? Keep in mind that we can't see your workbook from where we're sitting, so we need some more detail as to how you are using your workbook.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question