Filtering Values

[tomudell]

I also am new to vba's and have a few issues I am trying to solve. Excel file is attached

1st - If I have no date entered into the "Fume date" column under Fume Log then I want the date under the "Fume date" column under Fume report to be blank instead of reading 1/01/1900. it is set up now to duplicate the date but if no date has been entered yet it puts a stock date of 1-01-1900.

2nd - and most important
I want each row that contains Methyl Bromide to be duplicated on to the sheet labeled "Methyl Bromide" and if it contains the word Phosphine to duplicate that row to the sheet labeled "Phosphine". Basically I want to sort and duplicate my original sheet labeled "Log" into the other two sheets.
Thanks so much