Howdy All,

I have a spreadsheet that I want to copy certain info off to separate
sheets.

The sheet contains locations and dates, and I do a countif on the dates to
determine which is the latest and that cell is marked with a 1 in columns G
thru J. Only 1 of these columns will contain a 1.

I want to copy all the location info from column G to another worksheet to
separate it from the others (and so on with columns H, I, and J).

I can identify which location info I want, based on the 1's. If there is a 1
in a column, that info gets copied to the appropriate sheet.

Can someone show me how to do this?

Thanks,
Brian