Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rmbpjw
 
Posts: n/a
Default updating a spreadsheet in 1 field w/ out changing values in anoth

I am using a spreadsheet that was developed by a prior worker and I'm having
trouble sorting the product using one of the fields without it changing the
values in the other fields. I.E column 3 has been assigned a ranking number
based on its importance to our workforce. Column 6 has a seperate ranking
field with a priority status that ranks from 1-5. When I try to sort the
products by their priority status, their ranking number in column 3 realign
in sequential order. Help me to sort by column 6 with keeping column 3's
ranking assigned to their product.

Thank you,
TSgt M. Gibson
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach
 
Posts: n/a
Default updating a spreadsheet in 1 field w/ out changing values in anoth

What is driving the values in Columns 3 and 6? Formulas? VBA code?
If you don't know then, if you wish, send me a copy of your file via email.
If you feel your data is proprietary, then make a copy of your file first.
In the copy, change the data to nonsense and send that copy to me. I need
just the layout and the code (VBA code) and the formulas. My email address
is . Remove the "nop" from this address. HTH Otto
"rmbpjw" wrote in message
...
I am using a spreadsheet that was developed by a prior worker and I'm
having
trouble sorting the product using one of the fields without it changing
the
values in the other fields. I.E column 3 has been assigned a ranking
number
based on its importance to our workforce. Column 6 has a seperate ranking
field with a priority status that ranks from 1-5. When I try to sort the
products by their priority status, their ranking number in column 3
realign
in sequential order. Help me to sort by column 6 with keeping column 3's
ranking assigned to their product.

Thank you,
TSgt M. Gibson



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I format spreadsheet w/o changing font size? Amber W. Excel Worksheet Functions 0 March 27th 06 05:30 PM
How to keep leading zero without changing field to text field? Deni Excel Discussion (Misc queries) 1 October 24th 05 10:48 PM
I need to have only the values show in a spreadsheet. Debutante Excel Worksheet Functions 1 January 21st 05 07:59 PM
PivotTable Column Field Values Michael Rekas Excel Discussion (Misc queries) 2 December 10th 04 03:18 PM
Spreadsheet is only showing formulas not the actual values John Excel Worksheet Functions 2 November 24th 04 08:13 PM


All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"