I have this spreadsheet which combines the contents of six different spreadsheets in a specified location. The way it runs is that I have an Autpen routine on Sheet 1 to combine them once I open this spreadsheet.
Where I'm having trouble at is that in Sheet 2 of this spreadsheet, I have a table to set up to run a COUNTIFS formula based on two different sets of criteria. The formula works great when the spreadsheet is open. But once I close the spreadsheet and reopen it, it sets the values to "#REF" because the contents of the spreadsheet are deleted and rebuilt when I open it again. Is there anyway to get around this?
I'll provide more information if needed.
Where I'm having trouble at is that in Sheet 2 of this spreadsheet, I have a table to set up to run a COUNTIFS formula based on two different sets of criteria. The formula works great when the spreadsheet is open. But once I close the spreadsheet and reopen it, it sets the values to "#REF" because the contents of the spreadsheet are deleted and rebuilt when I open it again. Is there anyway to get around this?
I'll provide more information if needed.