Data Sort #ERR in copied data - Exel 2003

C

colindav

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
 
B

Bernie Deitrick

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

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Dilemma 6
Macro problem 2
How to update data from multiple sheets to one specific sheets 4
Filtering of data in a master excel sheet from multiple sheets 3
Expand and Shrink Rows and columns to hide information. 1
Sorting several columns 1
copying some rows and columns 21
Numbering a filtered list in Excel 2002 3

Top