Forum Discussion
Automatically Copying text from sheet to sheet
How do I get text on one sheet to automatically fill into another sheet on the same workbook? I'm trying to make a workbook that will allow me to type a scope of work for a job into an estimate sheet...
If you want text from your Estimate Sheet to automatically fill into your Scope of Work Sheet, here are three easy ways:
1️⃣ Simple Formula (Quickest Solution)
Just type this in the Scope of Work sheet:
='Estimate Sheet'!A1
Now, whatever you type in A1 of the Estimate Sheet will appear automatically.
Do the same for all the other cells you want to copy.
2️⃣ Power Query (For Tables)
Turn your data into a table (Insert > Table), then use Power Query (Data > Get & Transform > From Table/Range). Refresh when needed to pull updates.
3️⃣ VBA (For Auto-Updates Without Formulas)
Use this macro to instantly copy changes:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Sheets("Estimate Sheet").Range("A1:A100")) Is Nothing Then
Sheets("Scope of Work").Range(Target.Address).Value = Target.Value
End If
End Sub
Now, any update in A1:A100 of the Estimate Sheet will reflect immediately.
Best Option?
- Want it simple? → Use =A1.
- Working with tables? → Power Query.
- Need instant updates? → VBA.
Let me know if you need more help! 😊