<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message -->
I don't have access to the file right at this moment...but I will try to describe it the best I can. In Column A there is an empty cell with a gray background followed by about 5 cells of text (space between gray cells varies). I need to (if possible) be able to write something that looks for each gray cell in column A, copies the next two cells down from that gray cell, and pastes in in another sheet. That is probably the best I can do without seeing the sheet again...Any tips or advice is greatly appreciated, I'm not expecting anybody to write the code, but some pointers in the right direction would be great.
I don't have access to the file right at this moment...but I will try to describe it the best I can. In Column A there is an empty cell with a gray background followed by about 5 cells of text (space between gray cells varies). I need to (if possible) be able to write something that looks for each gray cell in column A, copies the next two cells down from that gray cell, and pastes in in another sheet. That is probably the best I can do without seeing the sheet again...Any tips or advice is greatly appreciated, I'm not expecting anybody to write the code, but some pointers in the right direction would be great.