Hi all,
I have a "master" spreadsheet and 3 other spreadsheets "Month","Vic", "Day"
all in the same workbook.
how can i create a macro that go through the "master" sheet and look at
column
D and E (in the same row) to find certain conditions:
if column D has "MVInd" and column E has the letter "M", then copy that row
to the spreadsheet "Month"
if column D has "COD" and column E has the letter "V", then copy that row to
the spreadsheet "Vic"
if column D has "OPTD" and column E has the letter "D", then copy that row
the spreadsheet "Day"
the macro should keep doing that until there is a blank row in the "master"
sheet.

Thank you very much.