Mar 10 2022 09:24 AM - edited Mar 10 2022 10:21 AM
Hi! I have a spreadsheet set up which talleys sales for each type of service sold each month (each month is an individual sheet) and then it has a summary sheet which talleys the amount of each service sold per month and annually. The sheet for March was accidentally deleted and I had to readd the month - I copy and pasted the set up of the sheet from another month. Now the summary sheet is giving #REF! errors for the entire March column as well as the total column. Ive tried Find and Replace. I cant seem to figure it out.
Please Help?
Mar 10 2022 09:36 AM
Mar 10 2022 10:18 AM
@mtarler Here is the Month of March as well as the summary sheet with the formula for Feb.
Mar 10 2022 10:19 AM
Mar 10 2022 11:19 AM
The table on the Mar sheet should be named ExpMar, but it is named ExpJan5.
Click in any cell of that table, for example in A2 on the Mar sheet.
Activate the Table Design tab of the ribbon.
Change the Table Name in the Properties group to ExpMar.
Switch to the Summary sheet.
Remove the apostrophe from before the formula in D5. It should now return a value.
Double-click the fill handle in the lower right corner of D5 to fill the formula down.
Mar 10 2022 01:41 PM