Data Input - Same Cell Across Multiple Sheets

[tthebert]

MrExcel Forum,

I have a question I was hoping someone here could help me answer.

Is there a way for me to input data into the same cell across different workbooks, similar to how you would for selecting multiple sheets and adding a value in a cell (i.e., typing 5 in selected cell A2, on sheet 1, while sheet 2 is also selected, will add 5 in cell A2 on sheet 2)

Essentially have 20 different workbooks with a the input for a date to price refresh the sheet as of that date in the same cell (call it O4). Instead of typing the date in on each sheet i'd like to type the date on all sheets.

Thank you

 

[SpillerBD]

Use Shift or CTRL to select the multiple sheets.
Then select the cell and enter the appropriate data.