Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update a column making sure new rows are created for new va
I've spent many hours entering data into a worksheet sent to me as a price
file from a vendor. The first column is a list of part#s, second is vendors' description, etc. I've created new columns and entered a lot of data, but now the vendor sent me an updated price file. The new file has all the original part#'s but there have been new part#'s added., and pricing has changed for all. How do I update the old worksheet with the current pricing, while creating new rows for the new part #'s? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update a column making sure new rows are created for new va
Peter,
Select and copy all the new stuff from the vendor, leaving out the headings -- just the actual records. Switch to the old workbook, and paste it directly under the stuff that's there. Any of this is undoable if it doesn't go just right -- you can try again. Now sort the table on the part number column, and Bob's your uncle. If there are duplicate part numbers, they'll be together. If you don't know how to sort with Excel, read "Sorting in Excel" at http://www.smokeylake.com/excel/excel_truths.htm. It can flat mess stuff up. Sorts are also undoable, by the way. Undoable always looks as though I've spelled it wrong. -- Earl Kiosterud www.smokeylake.com Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "PeterJKS" wrote in message ... I've spent many hours entering data into a worksheet sent to me as a price file from a vendor. The first column is a list of part#s, second is vendors' description, etc. I've created new columns and entered a lot of data, but now the vendor sent me an updated price file. The new file has all the original part#'s but there have been new part#'s added., and pricing has changed for all. How do I update the old worksheet with the current pricing, while creating new rows for the new part #'s? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update a column making sure new rows are created for new va
< Undoable always looks as though I've spelled it wrong.
I know what you mean, I always tend to change the syntax of the sentence and use 'can't undo' or 'can't be undone' or some such workaround. I also seem to have a mental block when reading it, my thought process usually runs along the lines of ... Undoble? Hey! What? oh undoable OK. <g Regards Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I update a column and create new rows for new column cells | Excel Discussion (Misc queries) | |||
Making a column of numbers created from a formula permanent. | Excel Worksheet Functions | |||
File asks to update when no links were created | Links and Linking in Excel | |||
Making Rows into Columns | Excel Discussion (Misc queries) | |||
How Do I created a nested sumif - if this column has this and thi. | Excel Worksheet Functions |