Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I update a column and create new rows for new column cells
I have hours and hours of work into a worksheet that was based off of a
simple price file sent by a vedor. Has a column for: part#, description, and cost. I've added many more columns for my own use. Now, vendor has sent an updated price file, where not only have the prices for each part# changed, but some new part#'s have been added. How do I "import" the updated part# list, along with the new pricing, while making sure new rows are created for the new part#'s in my master worksheet? Excel 2003 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I update a column and create new rows for new column cells
Pete has double-posted this question in this group.
-- 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... ----------------------------------------------------------------------- "Pete" wrote in message ... I have hours and hours of work into a worksheet that was based off of a simple price file sent by a vedor. Has a column for: part#, description, and cost. I've added many more columns for my own use. Now, vendor has sent an updated price file, where not only have the prices for each part# changed, but some new part#'s have been added. How do I "import" the updated part# list, along with the new pricing, while making sure new rows are created for the new part#'s in my master worksheet? Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning cells with the same value in a column, but on different rows. | Excel Worksheet Functions | |||
Printing only last 10 rows of the cells in a column | Excel Discussion (Misc queries) | |||
How do I get all cells both column and rows to print? | New Users to Excel | |||
after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
How do I update Column #1 based on specific value of column #2? | Excel Worksheet Functions |