Forum Discussion

Halfpint64's avatar
Halfpint64
Copper Contributor
Jun 13, 2022

Making totals change in date orderwhen a date is changed in another worksheet

Hi,

I have two worksheets.  One has a total row which I have linked to another worksheet in the same workbook.  The 2nd worksheet has the month in day by day.  The first worksheet date is changed day by day.  How do I make the second worksheet recognise the date is different and use the new totals?

 

Sorry if not clear.

 

Thanks

 

Formulas and Functions

3 Replies

  • mathetes's avatar
    mathetes
    Silver Contributor
    Jun 13, 2022

    Halfpint64 

     

    You wrote Sorry if not clear.

     

    Unfortunately, that is the case--it's not clear--and without more clarity it's next to impossible to offer suggestions. Would it be possible for you to either:

    1. give a much more complete description of what's in each sheet
    2. post a copy of the workbook itself (use Google Drive or OneDrive, ideally) and give us a link

    or both?

    • Charla74's avatar
      Charla74
      Iron Contributor
      Jun 13, 2022

      @Halfpint64 You can link a cell value to another cell, whether it be in the same sheet, another sheet within the same workbook or even a different workbook, simply by typing = and then selecting the cell containing the value you want displayed.  See attached example.

Resources