Excel Capture change in one cell and copy changes in other sheet

Question

I have multiple sheets in a workbook. Cell(A1) of every sheet has exactly the same text "Report for (month) (year)". every month only the month and year value changes. example: for February the text will be "Report for Feb 2013". How can I make changes in one sheet and the same change is copied to the remaining sheets ? I know how to copy cells but that way the code becomes lengthy .

Larry Larry · Accepted Answer · 2013-02-05T10:36:36

You can iterate all workshseets easily

Assume you have done it for the current sheet

Sub copyAOne()
    Dim ws As Worksheet
    Dim newValue As Range
    set newValue = ActiveSheet.Range("A1")
    For Each ws In Worksheets
        ws.Range("A1") = newValue
    Next ws
**PS** Please provide the code you tried in your question, and see if we can optimize it as well
end sub

Excel Capture change in one cell and copy changes in other sheet

1 Answers