View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 15
Default changing values acroos worksheets

Hello and good morning to all!

I got a problem...due to lack of experiance i didnt do
this ina better way.
I have a workbook with 33wrkshts. each worksheets in the
A2 column has a list of plant with the cost for each in
the A3 column. each sheet is a different lists (random).
one worksheets is a individual area.
so..here smy deal. i have a plantlist in a worksheet
alone and use it as a refernce for a userform.
now i recently discovered that the plant lists cost has
changed for many of the plants. Is there a way i can go
thru and change the values in A3 for the neccessary
plants.
If i had done a vlookup the first time around, i 'd be
okay.
but for now , is there a macro i need to create for this
or is there a function i do not know of to do this?

thanks again to all who helps?