Gord, Using your formula, can the same principle apply to data from different
workbooks all having identical worksheets and name ranges. If yes, (1)how
should
the formula be and (2) can the information be read from closed workbooks.
This is a late posting and I shall watch this topic for any responses.
Thank you,
RobertR