Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging Spreadsheet and matching data...
Dave O wrote: It's likely very possible, but we'd need to see some sample data so we know what data points are available to work with. Please post sample data. Ok... My main spreadsheet (tab delimited file) I have it setup as follows: A B C D ProductID49483 Brief Description Image.jpg 3.00 ProductID93094 Brief Description Image.jpg 5.00 ProductID30940 Brief Description Image.jpg 8.00 my alternate spreadsheet (tab delimited file) is as follows: A B ProductID49483 4.50 ProductID93094 8.50 ProductID30940 9.50 I want to make it so that I can Import my alternate spreadsheet into my main spreadsheet, but I only want it to alter column D on my main spreadsheet (changing prices). I need a macro, or a formula which will import column B from my alternate spreadsheet into column D in my main spreadsheet. I also need this macro/formula to be able to correspond the price with the correct productID...so it changes the correct product to its designated price. Any Ideas guys??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging spreadsheet data | Excel Discussion (Misc queries) | |||
Merging Data Into Spreadsheet | Excel Discussion (Misc queries) | |||
merging spreadsheet data | New Users to Excel | |||
Merging spreadsheet data | Excel Discussion (Misc queries) | |||
Matching/merging data from two worksheets | Excel Worksheet Functions |