Hi guys, really liking this macro stuff it's so useful and fun too.

I'm really stuck for time on my macro, spent a whole bunch of time on a macro that didn't work, was too long, and was incomplete.

I need to open a series of .htm files (source) in excel from a directory, apply text to columns on A7:A9, delimited by ":", then copy and transpose values from ranges' (B7:B9) of source to A1:A3 of destination. Then copy and transpose values from ranges B12:B18 of source to A4:A10 of destination. Then close the .htm without saving and open the next but print the result from source2 at B1:B10 of destination and so on in this manner.

Cheers from Canada!