Forum Discussion
#REF! 10 sheets linked to each other. When I delete a row i have to update each table in each sheet.
Help needed! These sheets are used for our weekly payroll. The ten sheets are linked to each other. 7 of the ten sheets have 9 individual tables. The first two sheets have the employees names. Once...
Hi Tom
Could you provide a workbook without the #REF!-errors?
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?
