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
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