Copy and Paste

I have one worksheet named "Data Check". The first row has the following columns: 12/31/2013 12/31/2014 12/31/2015 FALSE FALSE.

I would like to copy the dates from "Data Check" to another worksheet called "DCF Equity" and stop copying and pasting values when the macro hits "FALSE." Sometimes False may have another date like 12/31/2016. I don't know. So I would like to copy and paste cell values from one worksheet to another worksheet until the cell reads "FALSE" then stop copying pasting values.

Any ideas?

If Dates start from D1 and copied to other sheet form F1, In F1 and drag.

Please Login or Register  to view this content.

Thank you,

I do not want to copy the entire column but just the cell. How can I do that?

Todd