Seamus2626

asked on

# Data Table refresh

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

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

ASKER

Seamus2626,

Please see attached. Let me know if you want an explanation for the two formulas.

Regards,

Brian.test-V2.xlsx

Please see attached. Let me know if you want an explanation for the two formulas.

Regards,

Brian.test-V2.xlsx

ASKER

Hi Brian,

Thanks for the attached.

Can you please explain the formula?

Thanks!

Thanks for the attached.

Can you please explain the formula?

Thanks!

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thats spot on Brian!

This is just what i needed!

Thanks

This is just what i needed!

Thanks

Thanks, Seamus2626, glad to help!

Assuming that the data in A1:I16 is reading the tables by formula, could you post a copy with the formulas, please?

Thanks,

Brian.