Archive Row based on Input of cell

[bdavis215]

Hello,

Im wanting to take the entire row of data logged and move it to another sheet called "SR_Archive" after the word "Yes" is selected in the cell. I have 32 rows that span down from A3 to S3, I would like this to be a running archive so each time i select "Yes" it moves the data to the next sheet an doesn't write over existing data in the archive sheet. Any help on this would be greatly appreciated.

Thank you,
B

 

[mumps]

What is the name of the sheet that contains the logged data? In what column on this sheet is the word "Yes"?

 

[bdavis215]

The sheet name is "SandRidge Tracking" and the "Yes" is in column S

 

[Smitty]

Welcome to the Board!

It's generally a good idea to keep all of your data in one place. You can always use a Pivot Table and filter on the status field to display the Yes values.

 

[bdavis215]

Thank you - I am keeping the data on the same excel form, but would like to it to transfer data to another after has all been entered and shown complete. Can you do that with a pivot table. Im still some what of beginner at excel

 

[Smitty]

A Pivot Table won't physically move anything, it will just display information based on parameters that you set.