thanks Tom - this is what i was trying to do:
there is some information in a particular cell i was referencing (las
2 digits). the way i had it, it found the last 2 digits in the cel
and i had it enter it into D8 then copy the value in D9:D63. this wa
the information on page 1, so i copied the macros for page 2, 3, etc.
what i really would like it to do is find that particular cell on eac
page and enter the last 2 digits in each row. the cells i need to us
the last 2 digits are in A1, A58, A115, etc.
Any ideas would be greatly appreciated

--
acarri
-----------------------------------------------------------------------
acarril's Profile: http://www.excelforum.com/member.php...fo&userid=1002
View this thread: http://www.excelforum.com/showthread.php?threadid=26204