I am trying to create something that will look a a range of columns sa
B2 to G2 andsee if i have written ture in them

There will only be one cell that will be marked true at once

If i do i want to copy that column from range 2-13 or something t
another workbook

I have recorded a macro for the copying and I have found a for loop
can modify to look at each row for true. The If.Then statment is givin
me a really hard time. If anyone can help point me in the writ
direction I would be very greatful. Thanks

--
Message posted from http://www.ExcelForum.com