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

On Jul 20, 1:29*pm, lala...@hotmail.com wrote:
> 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."