View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zeewaa zeewaa is offline
external usenet poster
 
Posts: 2
Default Change values in multiple cells from one cell

I would like to change multiple cells values by just changing a value in one
cell. Example: I have a price sheet with multiple values I change at
different times. But I would like to change all the values based on my
customer. like if he is one of my higher users I would like to give him a
bigger discount.

What I would like is make a cell at the top of my workbook that would allow
me to put in a percentage value that I can change whenever I want want and it
will change all the values Ive selected to change that amount
--
John