updating source cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Bernie.
Thanks forthat. Would it be possible for you to give me some idea of what
the written command would look like?

Thanks.
 
Yes, if you:

Post back with:

1) the address of the cells that have the VLOOKUP formulas
2) the VLOOKUP formulas used

Bernie
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Database price updating 3
Formulas to Numbers 2
Need to display price in $ or £ dependant on supplier 6
Matching Values 1
product code a value 0
multiple calculations in 1 cell 1
vlookup column based on user input 5

Back
Top