Quote 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?