| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I sort or compare data from 2 different spreadsheet col
Dav, thanks! I'll give it a try
"Dav" wrote: If you wanted to avoid macro, I would paste both lots of data onto the same sheet in the same columns. If U then create a new column called product and copy the product description next to the parts it relates to. you can then run a pivot table, select all the data Choose PART NUMBER, DESCRIPTION, COST as row headings, product as column headings Quantity as data (it should default to sum which is fine) A new table will be created, if you then click on any of the totals they will be highlighted and can be deleted If you select the whole table then copy it as values elsewhere, you have a table that can be updated an dis not dependent upon data I hope this is clearish, if not please get back in touch Have fun Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=507086 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to compare 6 columns of text data | Excel Worksheet Functions | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| Can I sort excel spreadsheet data by fill color of cells? | Excel Discussion (Misc queries) | |||
| sort data in columns | Excel Discussion (Misc queries) | |||
| How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
Threaded Mode
