Hi,

I am fairly new to Excel so I'm not sure if this a Function problem or a Macro problem.

I have a spreadsheet with many columns and rows of data. I need to transfer rows of data from the first sheet to a second if a variable is true. One column('N') in the first table has true/false values. I need to filter through the entire column('N') for 'true' values and then copy each row of data with a 'true' value in column('N') into the second table.

Can this be done with a Function or do I need to use a Macro for this?
Please provide examples with your replies.