sorting

faucetparts · January 10th, 2006, 01:22 PM posted to microsoft.public.excel.newusers

I have 2 spread sheets, 1 has current part numbers (including old #s we do
not use any more) & currect inventory counts. The 2nd spread sheet, we
removed all old part numbers we no longer want in the system. During the time
it took to do this inventory values have changed. What I would like to do is
to merge our new part number list with current inventory list. Any ideas?

CLR · January 10th, 2006, 02:41 PM posted to microsoft.public.excel.newusers

I would use a helper column on the 2nd sheet with VLOOKUP formulas in it to
retrieve the current inventory numbers from the 1st sheet. Then they can be
reviewed, and if approved, replace the obsolete inventory numbers on the 2nd
sheet.

Vaya con Dios,
Chuck, CABGx3

"faucetparts" wrote:

I have 2 spread sheets, 1 has current part numbers (including old #s we do
not use any more) & currect inventory counts. The 2nd spread sheet, we
removed all old part numbers we no longer want in the system. During the time
it took to do this inventory values have changed. What I would like to do is
to merge our new part number list with current inventory list. Any ideas?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting	Michelle	General Discussion	0	December 5th, 2005 10:19 PM
sorting dates by month	Guate	General Discussion	0	September 27th, 2005 12:33 AM
Sorting a table by concatenating several fields in the same table	salsaguy	Running & Setting Up Queries	3	March 6th, 2005 08:41 PM
Sorting a table by concatenating several fields in the same table	salsaguy	Running & Setting Up Queries	0	March 6th, 2005 01:33 AM
triple sorting and twice sum	nowfal	General Discussion	1	July 16th, 2004 09:53 PM