On the attached ss, the two blue tables are linked to an Access Database and are refreshed via the button.
As you can see they cover rows 20-40
On refresh, some rows will be lost making the range more like 20-36
The data in A1:I16 is reading these data tables, so unless the data tables always have 20 rows, i get ref errors.
How can i essentially lock those data tables so they will always show 20 rows and if there is no data, they are just blank
Thanks!
test.xlsx
Assuming that the data in A1:I16 is reading the tables by formula, could you post a copy with the formulas, please?
Thanks,
Brian.