Forum Discussion
Solved
Table not populating using VSTACK
I have multiple sheets and each sheet has a table in it. I am using VSTACK to populate a "Dashboard" sheet that combines all the tables. Every table is working, except for one. When I try to put this...
- 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$30
NOT 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:
In the screenshot I am sharing the first formula results in a "0" and the second and third formula result in "1/0/1900"
