Can I Make My Code Run With A Change

[rockyw]

I made a simple copy paste code, can I make this run with a change? I did not see where I could set this. Thanks

 

[pedie]

I made a simple copy paste code, can I make this run with a change? I did not see where I could set this. Thanks

Yes, you can!
how does your code look like now and what are you wanting to do?

 

[rockyw]

It looks like this

Sub Macro1()
'
' Macro1 Macro
'
'
    Sheets("Sheet3").Select
    Range("E3:E24").Select
    Selection.Copy
    Sheets("Sheet2").Select
    Range("E3:E24").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub

I am pasting a reprot in sheet one, formulas on sheet 3 look for item numbers and fill cells on sheet 3, this code copies the data on sheet 3 and paste it in an area on sheet 2. I would like to have this run when the cells fill on sheet 3, auto move the dtat to sheet 2. Thanks