| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| 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 | |||
Linear Mode
