copying a row of data to another worksheet based on specific variable in one column

Hi all,

New to the forum, so direct me in the right spot if i'm off target.

I am wanting to copy a whole row of data from one sheet to another when a specific value is entered into a particular column. I have set this up with an advanced filter which seems to work fine however when i recorded the macro so I could update the sheets when I changed data in the specified column i found that for the macro to run accurately I had to delete all the information on the sheet. How can I get the data to automatically update (copy to the other sheet) when specified data is entered

Originally Posted by njohnsto

Hi all,

New to the forum, so direct me in the right spot if i'm off target.

I am wanting to copy a whole row of data from one sheet to another when a specific value is entered into a particular column. I have set this up with an advanced filter which seems to work fine however when i recorded the macro so I could update the sheets when I changed data in the specified column i found that for the macro to run accurately I had to delete all the information on the sheet. How can I get the data to automatically update (copy to the other sheet) when specified data is entered

It's a little difficult to tell why from the description. Could you post the macro code you're using please?

Also, are you wanting this macro to run automatically when data in the specific column is changed, or is it something which you will run from the menu or clicking an object to which the macro is attached?

So this is the macro:

Sub updatestat()
'
' updatestat Macro
'

'
Columns("A:O").Select
Selection.Delete Shift:=xlToLeft
Range("G11").Select
Sheets("Database").Columns("A:J").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("Database").Range("K5:K6"), CopyToRange:=Range("A1") _
, Unique:=False
End Sub


I do actually want the information to update automatically when information that meets the criteria range is either entered or deleted but as yet I haven't tried to do this.

Thanks for the help