Enter info into the directly to the right

[Yandeez]

Hi,

I have an excel workbook with 22 worksheets. I need to be able to enter the same info. in the cell directly to the right of a specified cell. Please see attached sample. Next to Kellog's in every sheet, I need to be to enter Fruit Loops. This file is hypothetical of course, I simply need the formula. Any help is greatly appreciated.

 

[Luke M]

Select all the sheets, then type desired value into desired cell. Change will be made to all selected sheets.

 

[Yandeez]

Sorry Luke - I should've clarified. The specified cell appears in different cells on every worksheet. If I select all sheets and enter the desired value, it will add that value in each cell across all the sheets. I need it to enter the value only if the cell directly to the left says "Kellog" for example.

 

[Luke M]

I would suggest then creating a lookup table somewhere, showing which values goes with what, and then putting a lookup type formula in all the sheets.

 

[Yandeez]

Good idea! Thanks for your help as always Luke!