Debbie
I have done much the same thing many times. For my needs I just wrote a
macro to populate the "print" sheet and do the printing and all. Updating
the row number in a number of formulas every time you want to update and
print is not the way to go. The macro can be written to use the last row as
the source or to use the current row as the source. Post back if you are
interested in this approach. HTH Otto
"Debbie L." <Debbie wrote in message
...
I have one excel spreadsheet that I am inputting data for tracking
purposes.
I need
to also print out this information, in a different format, and forward to
an
end
user. I have set up a second excel spreadsheet in the format necessary.

Currently the information from spreadsheet 1 is automatically populating
into
spreadsheet 2. BUT- for every record I add I have to continually go into
spreadsheet 2 and update the row number within the formula to pull in the
correct data. Is there a way so that as I key in each row - the record
will
automatically populate correctly within spreadsheet 2?