Thank you in advance for any assistance! I truly value any advic
given!
I have 3 columns. Column 1 displays contrac ID for about 10 contracts
Column 2 is either blank or has the word "Flow" depending on th
lifetime of the contract in relation to the current date. Column 3 i
blank.
Would it be possible to loop through a selected range in column 2 an
if the word "Flow" appears, then take the contract ID in column 1 an
transfer it to column 3 -- one after the other so that the blanks i
column 2 are eliminated?
So far, I have only been able to come up with this code:
Sub CURRENT_CONTRACT()
Set rng = Range("G4:G13")
Sheets("CONTRACTS").Select

For Each Cell In rng
If Cell.Value = "Flow" Then

Unfortunately, I don't have the knowledge to advance in a clear manne
from here. Sorry. Thanks again for any assistance

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