Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data sort excel 2003 | Excel Worksheet Functions | |||
exel 2003 suddenly stopped allowing data entry | Excel Discussion (Misc queries) | |||
How do you sort copied from internet data in Excel? | Excel Discussion (Misc queries) | |||
New data will not sort with existing data from copied file | Excel Worksheet Functions | |||
In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. | Excel Worksheet Functions |