ExcelBanter - Prevent equation from skipping data when referencing import data?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Prevent equation from skipping data when referencing import data? (https://www.excelbanter.com/excel-discussion-misc-queries/43037-prevent-equation-skipping-data-when-referencing-import-data.html)

lybrt98

Prevent equation from skipping data when referencing import data?

I am referencing data that is being imported from access in table on a
seperate worksheet. When the data is refreshed, only the last new entry is
placed in my seperate table, not all of them. How do I fix this?

All times are GMT +1. The time now is 01:05 PM.