Home |
Search |
Today's Posts |
#1
|
|||
|
|||
updating source cells
Hi.
I have a spreadsheet where the user selects a product from a dropdown list. this list is connected to a vlookup that produces a cost (in another cell) based on the product chosen. I want the user to be able to update the price list by simply entering a new price for that product into the cost cell & then have excel save the newly entered cost back to the worksheet that contains all of the costings. Is this possible? Can you help??? Thanks :) |
#2
|
|||
|
|||
Hey newbie,
You would need to use the worksheet change event. Post back with: 1) the address of the cells that have the VLOOKUP formulas 2) the VLOOKUP formulas used HTH, Bernie MS Excel MVP "excelnewbie" wrote in message ... Hi. I have a spreadsheet where the user selects a product from a dropdown list. this list is connected to a vlookup that produces a cost (in another cell) based on the product chosen. I want the user to be able to update the price list by simply entering a new price for that product into the cost cell & then have excel save the newly entered cost back to the worksheet that contains all of the costings. Is this possible? Can you help??? Thanks :) |
#3
|
|||
|
|||
Hi Bernie.
Thanks forthat. Would it be possible for you to give me some idea of what the written command would look like? Thanks. "Bernie Deitrick" wrote: Hey newbie, You would need to use the worksheet change event. Post back with: 1) the address of the cells that have the VLOOKUP formulas 2) the VLOOKUP formulas used HTH, Bernie MS Excel MVP "excelnewbie" wrote in message ... Hi. I have a spreadsheet where the user selects a product from a dropdown list. this list is connected to a vlookup that produces a cost (in another cell) based on the product chosen. I want the user to be able to update the price list by simply entering a new price for that product into the cost cell & then have excel save the newly entered cost back to the worksheet that contains all of the costings. Is this possible? Can you help??? Thanks :) |
#4
|
|||
|
|||
Yes, if you:
Post back with: 1) the address of the cells that have the VLOOKUP formulas 2) the VLOOKUP formulas used Bernie "excelnewbie" wrote in message ... Hi Bernie. Thanks forthat. Would it be possible for you to give me some idea of what the written command would look like? Thanks. "Bernie Deitrick" wrote: Hey newbie, You would need to use the worksheet change event. Post back with: 1) the address of the cells that have the VLOOKUP formulas 2) the VLOOKUP formulas used HTH, Bernie MS Excel MVP "excelnewbie" wrote in message ... Hi. I have a spreadsheet where the user selects a product from a dropdown list. this list is connected to a vlookup that produces a cost (in another cell) based on the product chosen. I want the user to be able to update the price list by simply entering a new price for that product into the cost cell & then have excel save the newly entered cost back to the worksheet that contains all of the costings. Is this possible? Can you help??? Thanks :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Source Name Not Found | Excel Worksheet Functions | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
External Data Source updating on open, how to turn back on prompt. | Excel Worksheet Functions | |||
updating linked cells | Excel Discussion (Misc queries) | |||
Excel 2003 isn't updating my cells | Excel Worksheet Functions |