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 :)

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 :)

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 :)

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 :)