Data Sort #ERR in copied data - Exel 2003
 

I have rows numbered 1 - 500+ in column A. The rows are numbered by adding 1
to the above cell i.e. A2 =A.1+1. I copy the entire sheet to sheet 2 for
sorting but the row numbers return #ERR! when sorted by reference to any
other column. How can I keep the formula for numbered rows in sheet 1 but
make them absolute on sheet 2 so they give the number assigned to them in
sheet 1? I've looked for an answer without success so resort to this posting.
Help much appreciated. Thanks

Data Sort #ERR in copied data - Exel 2003
 

Paste values instead of formulas - then they won't change.

HTH,
Bernie
MS Excel MVP


"colindav" wrote in message
...
I have rows numbered 1 - 500+ in column A. The rows are numbered by adding 1
to the above cell i.e. A2 =A.1+1. I copy the entire sheet to sheet 2 for
sorting but the row numbers return #ERR! when sorted by reference to any
other column. How can I keep the formula for numbered rows in sheet 1 but
make them absolute on sheet 2 so they give the number assigned to them in
sheet 1? I've looked for an answer without success so resort to this posting.
Help much appreciated. Thanks

Data Sort #ERR in copied data - Exel 2003
 

Thanks Bernie, problem solved and much appreciated

Colin

"Bernie Deitrick" wrote:

Paste values instead of formulas - then they won't change.

HTH,
Bernie
MS Excel MVP


"colindav" wrote in message
...
I have rows numbered 1 - 500+ in column A. The rows are numbered by adding 1
to the above cell i.e. A2 =A.1+1. I copy the entire sheet to sheet 2 for
sorting but the row numbers return #ERR! when sorted by reference to any
other column. How can I keep the formula for numbered rows in sheet 1 but
make them absolute on sheet 2 so they give the number assigned to them in
sheet 1? I've looked for an answer without success so resort to this posting.
Help much appreciated. Thanks