drums4monty
03-05-2008, 03:26 AM
Hi
I have a work book with 62 sheets, each sheet is named after a club. In cell B21 is the word Members, in B22 the word Staff and in B23 the word Red. There is a price in cells I21, I22 & I23. I need to update these prices which I could do but not all of the sheets have all of the data, for example sheet 1 has Members & Staff, but sheet 2 has Members, Staff & Red. Is there a way to update I21, I22 & I23 with the new data, which is ?6.14, ?0.38 & ?34.30, but only if that club requires the data? All clubs require the first 2 new prices and only certain ones require the price for Red.
I have a work book with 62 sheets, each sheet is named after a club. In cell B21 is the word Members, in B22 the word Staff and in B23 the word Red. There is a price in cells I21, I22 & I23. I need to update these prices which I could do but not all of the sheets have all of the data, for example sheet 1 has Members & Staff, but sheet 2 has Members, Staff & Red. Is there a way to update I21, I22 & I23 with the new data, which is ?6.14, ?0.38 & ?34.30, but only if that club requires the data? All clubs require the first 2 new prices and only certain ones require the price for Red.