Macro assistance (might be tricky)
 

Throughout my spreadsheet the word "Date" appears a number
of times (in Column I). Where it does appear it is often
followed by other information (in the same cell).

I would like to write a macro that takes note of every
occurence of this and then copies the contents of column H
(not I) into sheet2

Any ideas ?

Macro assistance (might be tricky)
 

Hi
have a look at:
http://www.rondebruin.nl/copy5.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Sean" schrieb im Newsbeitrag
...
Throughout my spreadsheet the word "Date" appears a number
of times (in Column I). Where it does appear it is often
followed by other information (in the same cell).

I would like to write a macro that takes note of every
occurence of this and then copies the contents of column H
(not I) into sheet2

Any ideas ?