So I have a workbook with three sheets.
Master - this contains the full data
Destroyed and Retained
Within Master there is a column (G) that has a "Y" to indicate that the file has been destroyed and an "N" to indicate that the file is retained. Currently some are blank but these will be changed as and when the documents are reviewed. There will also be further data added to the master sheet as time goes on.
The headings in all three sheets will be the same
What I am after is either a code or a formula that scans the master sheet and copies the entire row (columns A to M) into destroyed and retained dependant on column G (the Y/N). I would need this to either update dynamically or through the push of a button prior to exiting. Currently I'm manually adding them b y copy pasting and then sorting them by date, its rather laborious and repetitive!
I had a go using FILTER but couldn't work it out.
Grateful of any assistance.
Master - this contains the full data
Destroyed and Retained
Within Master there is a column (G) that has a "Y" to indicate that the file has been destroyed and an "N" to indicate that the file is retained. Currently some are blank but these will be changed as and when the documents are reviewed. There will also be further data added to the master sheet as time goes on.
The headings in all three sheets will be the same
What I am after is either a code or a formula that scans the master sheet and copies the entire row (columns A to M) into destroyed and retained dependant on column G (the Y/N). I would need this to either update dynamically or through the push of a button prior to exiting. Currently I'm manually adding them b y copy pasting and then sorting them by date, its rather laborious and repetitive!
I had a go using FILTER but couldn't work it out.
Grateful of any assistance.