Forum Discussion

Tom Cunniffe's avatar
Tom Cunniffe
Copper Contributor
Apr 10, 2017

#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...
Formulas & Functions
Need Help
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 10, 2017

Hi Tom

 

Could you provide a workbook without the #REF!-errors?

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Apr 11, 2017

    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.

     

    • Tom Cunniffe's avatar
      Tom Cunniffe
      Copper Contributor
      Apr 11, 2017

      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?

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Apr 11, 2017
        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.

         

Resources