I have one sheet with 3 (A:C) columns. Where column C contains the value 'Y' I'd like to move the entire row to compile a new data set in a second sheet. Both sheets have header rows.
Eg. mudmap below
Sheet 1 : how it looks
[/URL][/IMG]
Sheet 2 : How i'd like it to look!
[/URL][/IMG]
Simple formula/ macro? THANKS!
Eg. mudmap below
Sheet 1 : how it looks

Sheet 2 : How i'd like it to look!

Simple formula/ macro? THANKS!