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 ?