Data Sort #ERR in copied data - Exel 2003

  • Thread starter Thread starter colindav
  • Start date Start date
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
 
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

Copy data from unlocked cells 3
How to insert new worksheet based on # of rows in a data sourch 2
Copying data to the next blank row 0
Sorting Dilemma 6
Copy and Sort Unique 2
copy rows from one Data sheet to another sheet based on cell conte 2
Copying cell formulas 1
Autosort in Excel 2

Back
Top