Forum Discussion
Table not populating using VSTACK
- I was able to fix the problem by re-creating the table. I found that the issue was with the formulas I was using to calculate dates (when I would copy and paste the content as plain text the VSTACK worked). So I recreated the table and reapplied the formulas for dates and it worked.
I do not know why the formulas in the first table were not working originally as they are the same ones used in the current table that is working.
EllenC53715 Your name contains relative references. This means the range pointed to will be different depending on the location of the formula that uses the range name. IN name manager, the correct formula should look like this:
='Badgers Belong Day'!$A$1:$J$30NOT like this:
='Badgers Belong Day'!A1:J30- When I do the formula you suggest it returns a single cell of "1/0/1900"
EllenC53715 "1/0/1900" is displayed because the number formatting for the cell is date. Would you please turn on Show Formulas and to show the formula and capture the screen as shown here:
- [Create a 3-D reference to the same cell range on multiple worksheets - Microsoft Support](https://support.microsoft.com/en-us/office/create-a-3-d-reference-to-the-same-cell-range-on-multiple-worksheets-40ca91ff-9dcb-4ad1-99d2-787d0bc888b6) could be relevant too for your task.
Since it has a space, could you wrap it in single quotes ='Badgers Belong Day 2'!A1:J30.
I just tested it in the web version of Excel, it does accept the name when you enter it without quotes, whereas in desktop version will not allow it. Anyway, while in Refers To, it is easier to navigate to the sheet with the range and select it. Then you will get correctly formed reference.
- Doing this resulted in a single cell being filled with a date of 1/0/1900.
Did you try to edit BadgerBelog2? If you haven't please try to edit it, while in Refers To, navigate to the sheet with the range and select it. Then you will get correctly formed reference.
