Forum Discussion
#REF! 10 sheets linked to each other. When I delete a row i have to update each table in each sheet.
Tom, your workbook is just a bunch of criss-cross referencing and nothing what could be considered as a model.
My advice is that you redo the workbook and establish a model.
That includes using lookup fuctions as INDEX()/MATCH() or VLOOKUP() or pivot tables.
Never heard of; Index, Match or VLookup functions before. Is it a matter of inputting those functions in my already strcutured worksheet or will I have to start from scratch?
Tom Cunniffe wrote:Never heard of; Index, Match or VLookup functions before.
Wow, then you have something to catch up.
It may be possible to put lookup formulas instead of direct references in your workbook [1], but I still advise to start from scratch.
Basically you need one list [2] for input data and on other sheets the output with formulas or pivot tables.
[1] I didn't check because I don't know how the workbook is supposed to work.
[2] In regard of [1] it could be more than one list with input data.
Hi Tom,
I think you would be better off starting from scratch again. Your current file is a very intertwined set of direct cell-to-cell formulas which "break" as soon as you try to do important things like adding or removing people. Even doing more simple things like sorting the information is problematic. Without thorough knowledge about what your Excel file needs to do it is quite hard to advise how to set it up properly however. I would start by looking in Help for what the VLOOKUP function can do for you.
