Copy Data from one sheet to another

[yoplumpy]

Hi
I have been asked to set up a workbook with 5 sheets. The Master sheet will hold all records - but they want the data to be copied to another sheet based on entering a value (for example "Reason" - from a list) into one of the cells.
So if the reason was "eye test" the record would be copied to a pre-name sheet that would collate all records stating that reason (does that make sense?)
Is there a way to do this that isn't too complicated? Any help would be great!
Paul

 

[SteveO59L]

Could you not reference all records on the master sheet and use a filter on the specific sheets?

 

[yoplumpy]

Hi Steve

Referencing the cell was an idea - but filtering would mean that all records are referenced on all sheets - and that means there is potential for confusion should someone remove the filter! Can a filter be applied in another way?

Cheers

 

[SteveO59L]

You could use a worksheet activate event to hide the rows you dont want to show. Depends how complex you want to get

 

[yoplumpy]

I'll look into that - cheers.

Paul