Copy Row depending on an entry

[lalabop]

Hello
This topic has been done to death or so I thought until I attempted to
use what I thought was a good example...
I have rows of data and in some cells there are links - these cells
are not adjacent!
I am guessing all you guru's out there are already sighing out
loudly...
I would like a macro that will look at cells in column T and if a date
has been entered copy the row to another sheet (Target sheet). The
host row needs to be cleared but those cells with links to remain.
From what I have read the latter is not possible but I did wonder if
the macro could therefore return to the copied cells copy the links
and take them back to the host. But this is only a suggestion and
being rubbish at VB cannot even dream of constructing a solution.

So if any of you are feeling charitable:
The data row starts from row 4
The cells with the links are in columns G & H and M & N
The date will appear in Row T

Thanking you in advance

Bops

 

[Don Guillett Excel MVP]

Hello
This topic has been done to death or so I thought until I attempted to
use what I thought was a good example...
I have rows of data and in some cells there are links - these cells
are not adjacent!
I am guessing all you guru's out there are already sighing out
loudly...
I would like a macro that will look at cells in column T and if a date
has been entered copy the row to another sheet (Target sheet). The
host row needs to be cleared but those cells with links to remain.
From what I have read the latter is not possible but I did wonder if
the macro could therefore return to the copied cells copy the links
and take them back to the host. But this is only a suggestion and
being rubbish at VB cannot even dream of constructing a solution.

So if any of you are feeling charitable:
The data row starts from row 4
The cells with the links are in columns G & H and M & N
The date will appear in Row T

Thanking you in advance

Bops

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."