copy and paste TRUE records in new spreadsheet

[clairebelle]

Hi there,

I have two spreadsheets that I have cross referenced, and the entries that turn up on both spreadsheets have a column that says "TRUE" or "FALSE". I need the "TRUE"s to turn up on another spread sheet.

Details:

All true records in sheet 3 that have the true value in colum G need to turn up in another sheet (say, sheet one); i.e. copy columns A-F if of a row that has true in column G. Copy them into colums A-F of a new spread sheet.
AND
All true records in sheet 2 that have the true value in colum D need to turn up in another sheet (say, sheet one); i.e. copy columns A ONLY if of a row that has true in column D. Copy them into colums G the same spread sheet as the ones above were copied into.

Thanks in advance.. I wouldn't know where to start


Claire