copy cells from one sheet to an other if of a certain value

[Broccoli]

Hello,

I'm trying to copy data from one sheet to an other if Column F is of a certain value.
For example If cloumn F from the master sheet has a value of 1150 then copy all rows and column for those to the SRMDMC-1150 sheet with headers... Is there a copyif function?

Attached is my workbook.... I'll have to do this for all sheets as noted.

Thanks!!

[rylo]

Hi

Have a look at the advanced filter function. If you start off on your destination sheet, then do an advanced filter (with the relevant selection criteria somewhere) then the filter can be used to transfer the data to the output sheet.

rylo

[Broccoli]

Great! Thank you! I'll try it.