PDA

View Full Version : Solved: Updating Cell Info



drums4monty
03-25-2009, 07:53 AM
Hi

I need to update the information in a cell. The workbook has 61 sheets and I need to change a figure in a cell in a row named Card Printer Ribbons to 67.14. My problem is that the cell is either I32 or I33, although the tiltle of the row remains the same. Is there a way of doing this without having to change each row by hand?

To recap:

The cells that need changing to 67.14 are either I32 or I33
The title of the row is called Card Printer Ribbons
There are 61 sheets

lucas
03-25-2009, 08:01 AM
Did you make a copy and then select all the sheets and use find/replace?

drums4monty
03-25-2009, 08:05 AM
Thanks for that Lucas, did not think of that.