Hi there,
I have a table in excel which looks up to a range on another sheet within the document. At the moment, only the top row in the table holds the lookup formulas, and I have a cell next to the table which counts the rows in the range, to tell the user how many rows to drag the table down.
I wonder if, instead of having the user drag the cells down, the table could figure out how many rows to populate itself, by looking at the range?
Bookmarks