On Saturday, February 14, 2015 at 2:03:31 AM UTC-8, L. Howard wrote:
On Saturday, February 14, 2015 at 1:43:01 AM UTC-8, GS wrote:
I added some formatting to Sheet2.colA, and inserted headers in row1
with row CF.

Have a look at "Book3_v2.xlsm" here...

https://app.box.com/s/23yqum8auvzx17h04u4f

--
Garry


Okay, will do.

Appreciate the code, works well and packs the color format as advertised!
(And date formats)

Tnx,

Howard

Garry, the headers are indeed a nice touch.

Probably will really be useful given that there are 26 columns of data going to the destination sheet.

Thanks.

Howard