Forum Discussion
Halfpint64
Jun 13, 2022Copper Contributor
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 da...
mathetes
Jun 13, 2022Silver Contributor
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:
- give a much more complete description of what's in each sheet
- post a copy of the workbook itself (use Google Drive or OneDrive, ideally) and give us a link
or both?
Charla74
Jun 13, 2022Iron Contributor
@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.
- Halfpint64Jun 13, 2022Copper Contributor
Charla74thanks, I think I need macros.