Automatic Copy of Text from 1 cell on 1 sheet to another cell on another sheet within a workbook

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!

Answer
Answer

Why not set up formulas to reference the cells in sheet1  for example if you want Joe's Resturant in Sheet2 cell A1 when that is entered in Sheet1 cell A1  then in A1 of sheet2

=Sheet1!A1

If the information if in A1:A4, just copy the formula down.  If you don't want to see 0's before you have data enter the following in A1 of sheet2

=IF(Sheet1!A1="","",Sheet1!A1)


If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire
Shane Devenshire

192 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated February 25, 2025 Views 107,182 Applies to: