Struggled with the heading, here is my situation.
I have a sheet that pulls employees names from a master employees sheet and places the names in column A
We input data relevant to each employee in columns B, C, D, and E
I need to find a way that when the sheet imports the names, the cells in columns B, C, D and E move with the name
So if Fred is in cell A4 and in cell B4 has information about Fred, the import puts a new name in cell A4 it will move Fred and the relevant adjacent cells down.
Each day has a different sheet, and is saved as the date it is relevant for, the only sheet that stays the same is the master employees sheet.
I have it pulling in the names ok, but it messes up the other cells as they stay in place and the names move.
RDACS snap shot.png
Bookmarks