I don't have a list of the loan numbers....Is there anyway to add the
tab names to this code? Also, since I have more than one cell I do
need to grab, how do I change the code to copy a second cell, ie A2,
into Column B? In addition, there is a third cell I'd like to grab,
but it varies on each sheet. The common bond between them is its in a
column where in the top cell the word Balance is entered. I need the
last cell in the column. I'm thinking a macro can handle doing a find,
then end down to find this value, Right??