|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 5th, 2005, 02:57 PM
|
|||
|
|||
Sorting problem, sums change
I have a spreadsheet with 12 worksheets. It totals fine the way it is, but
on several of the worksheets I need to sort them by State, when I do, the totals change. It calls data from one of the other worksheets cells which remains the same. Once I sort one of the worksheets the data pulling from the other worksheets now displays #DIV/0! and my totals are wrong at the bottom. Any suggestions. 
|
|
#2
February 5th, 2005, 03:45 PM
|
|||
|
|||
|
Just a thought.
Copy "Values" to another column, and then sort that column, and perhaps hide the original. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Mychele" wrote in message ... I have a spreadsheet with 12 worksheets. It totals fine the way it is, but on several of the worksheets I need to sort them by State, when I do, the totals change. It calls data from one of the other worksheets cells which remains the same. Once I sort one of the worksheets the data pulling from the other worksheets now displays #DIV/0! and my totals are wrong at the bottom. Any suggestions.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sorting problem | JC | General Discussion | 3 | January 28th, 2005 03:27 AM |
| Spell Check language change problem | Jackie | General Discussion | 3 | June 10th, 2004 10:25 AM |
Linear Mode
