Forum Discussion

PDCAWP's avatar
PDCAWP
Copper Contributor
Jan 27, 2025

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 and have it automatically fill into a scope of work sheet that is specifically for printing out.

admin
excel
Formulas and Functions
Macros and VBA
training
  • insightsgeek's avatar
    insightsgeek
    Brass Contributor
    Jan 29, 2025

    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! 😊

Resources