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.
Can you show us your formula please? Are you sure the # of columns are equal for all sheets you're referring to?
Yes there are the same number of columns in all tables.
=VSTACK(Table1, Table2, Table 3....)
=VSTACK(Table1, Table2, Table 3....)