sorting in Excel 2003

BluesMatt · 02-08-2007

I have a large workbook with many worksheets. The first worksheet has part numbers and prices. All of the remaining worksheets refer to the part number price sheet. When I sort the part number/price sheet, the references in all of the other worksheets do not get updated so they are all wrong.

If I manually sort the part number/price sheet by dragging rows around, the references in the other sheets get updated and remain correct.

Is there a way to have the computer sort the first sheet and keep all of the references in the other sheets correct?

thanks................................matt

ladygreenwitch · 02-10-2007

Hey Matt!

What formula are you using for your references?

Looking forward to your reply,

TTFN

LGW

BluesMatt · 02-13-2007

I'm using a simple equate. I move to a cell on one of the worksheets, press "=", then move to the cell on the Main Sheet and press return.

The problem is when I sort the Main Sheet, the references used in the formulas on the other sheets do not update.

thanks................matt

ladygreenwitch · 02-14-2007

Hey Matt,

This would probably be simpler if you were to attach the page of your workshee that has the referenced information, and one of the worksheets as an example. That way I can show you exactly how to referrence the information so that the worksheet will do what you want it to do.

Looking forward to your reply,

TTFN

LGW

02-08-2007	#1
BluesMatt Bronze Member Join Date: Apr 2006 Location: Connecticut Posts: 94 PC Experience: Experienced	sorting in Excel 2003 I have a large workbook with many worksheets. The first worksheet has part numbers and prices. All of the remaining worksheets refer to the part number price sheet. When I sort the part number/price sheet, the references in all of the other worksheets do not get updated so they are all wrong. If I manually sort the part number/price sheet by dragging rows around, the references in the other sheets get updated and remain correct. Is there a way to have the computer sort the first sheet and keep all of the references in the other sheets correct? thanks................................matt

02-10-2007	#2
ladygreenwitch Elite Member Join Date: Jul 2005 Location: Bay Area California Posts: 6,615 PC Experience: Very Experienced	Hey Matt! What formula are you using for your references? Looking forward to your reply, TTFN LGW __________________ PreWork/ AfterWork/ CCleaner/Spybot S&D/ Spyware Blaster/ Adaware SE/ Memtest86/ Shoot the Messenger/ Housecall/ Belarc/ Registry Cleaner/ Bootdisk.com/ XP Install/PCHF Protect Your PC

02-14-2007	#4
ladygreenwitch Elite Member Join Date: Jul 2005 Location: Bay Area California Posts: 6,615 PC Experience: Very Experienced	Hey Matt, This would probably be simpler if you were to attach the page of your workshee that has the referenced information, and one of the worksheets as an example. That way I can show you exactly how to referrence the information so that the worksheet will do what you want it to do. Looking forward to your reply, TTFN LGW __________________ PreWork/ AfterWork/ CCleaner/Spybot S&D/ Spyware Blaster/ Adaware SE/ Memtest86/ Shoot the Messenger/ Housecall/ Belarc/ Registry Cleaner/ Bootdisk.com/ XP Install/PCHF Protect Your PC

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

02-13-2007	#3
BluesMatt Bronze Member Join Date: Apr 2006 Location: Connecticut Posts: 94 PC Experience: Experienced	I'm using a simple equate. I move to a cell on one of the worksheets, press "=", then move to the cell on the Main Sheet and press return. The problem is when I sort the Main Sheet, the references used in the formulas on the other sheets do not update. thanks................matt