Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update rows with new pricing
I receive daily updates from various suppliers. Instead of dragging and
dropping their new data into my one master price list, I would like to have Excel look up and replace the old prices with the new prices into my list for each supplier. Is there an easier way of doing this instead of doing so manually (drag and drop)? The daily updates can be anywhere from 5 entries to over 3,000. 5 is ok to do manually, but 3,000...yikes! I have 2 columns within my lists which are identical to 2 columns from each of my suppliers. Each supplier's price list contains approximately 8 columns. I need to ensure I replace the data into the proper row and thought Excel could perform this tedious task in short order. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
insert rows and update linked cells | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |