Power Platform Community Forum Thread Details

Hello,

I have an Excel spreadsheet in which I would like to add some automation so that when some data is entered in Sheet A it is automatically copied in Sheet B, and can be copied in Sheet C when requested.

Also, I would like that when data is deleted from Sheet A, it also deletes in Sheet B and can't be available in Sheet C.

I also want that when a row is added in Sheet A, it's automatically added in Sheet B; and one can't add a row in Sheet B manually.

Thanks for any help

Categories:

General topics

⚡️ Approach: Using Excel Formulas and VBA

1️⃣ Sheet B auto-syncs with Sheet A

In Sheet B:

Use formulas to mirror Sheet A’s data.
Example: In cell A1 of Sheet B:

=IF(SheetA!A1<>"", SheetA!A1, "")

Drag this formula across and down to cover the same area as Sheet A.
This way, Sheet B always mirrors Sheet A automatically—no manual edits!

Prevent editing in Sheet B:

Protect the sheet so users can’t manually add rows or edit cells.

2️⃣ Deletion syncs automatically

Because Sheet B uses formulas, if data is deleted in Sheet A, it’s instantly gone in Sheet B.

3️⃣ Sheet C – Controlled Copy

For copying to Sheet C only when requested, use a macro (VBA):

Sub CopyToSheetC()
    Dim wsA As Worksheet, wsC As Worksheet
    Set wsA = Sheets("SheetA")
    Set wsC = Sheets("SheetC")
    
    wsC.Cells.ClearContents 'Optional: Clear old data
    wsA.UsedRange.Copy Destination:=wsC.Range("A1")
End Sub