I want to fill in a text cell in Sheet 1 as "Joe's Restaurant" and have "Joe's Restaurant" auto-populate to another cell in another sheet. Bascially I'm trying to title a workbook and have each sheet NOT require me to type in the Event, the dates, the city, the state, etc, etc.
As you all know, the answer is prolly in F1, but I don't know how to phrase the question to get my answer.
Thx!