I created a macro to gather a short list of data items for some numbers that
are in 3 different spreadsheets (all identical, just a different series of
numbers on each).

I started the macro by telling it to go to a hard location in the first
spreadsheet (where the list of numbers starts), then end-arrow down to the
last number, then over to the next column where I have a vlookup function.
Each day, the list on each spreadsheet may be shorter or longer, depending on
which numbers are chosen.

My macro unfortunately uses the same quantity of numbers on each spreadsheet
each time, remembering the number of rows down when first created.

How can I alter it so that it knows to stop at the last number in the list,
regardless of how many are in the list, and be able to do it again when the
list becomes shorter or longer?
--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle