Phil,
Thank you - all good info, especially the last post. This will save me
hours of time and cross-checking. I appreciate your help!!

Cynthia
--
Cynthia


"Phil" wrote:

Woops - DON'T do the search/replace thing - Just put a $ in front of
the A in the first formula before you copy horizontally. The column
letter won't change because of the $, and neither wil the row no's
'cos your filling horizontally. However you do need them to change
when you copy the lot vertically.

Hope that makes some sense!

Phil