Forum Discussion
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....)
- Is the offending table empty by any chance? Or perhaps the table doesn't span the expected range of cells?
- No, the table has quite a bit of data and spans the expected range with the same number of columns as all the other tables.
- Can you perhaps replace the data in the tables with dummy data and share the workbook in question? Perhaps all that is needed are two tabs: one that works in the VSTACK and one that does not.
