Hi all, I think i've got it pretty much working now - although is i
possible to get a new list of headers inbetween the customer result
and the supplier results?

jan feb mar etc
2 3 4 1
jan feb mar etc
1 4 3 2

I think it would mean just putting one line of code in to say when yo
create a new worksheet to put the headers at the top AND the bottom?

Hope someone can help ??

--
GazM
-----------------------------------------------------------------------
GazMo's Profile: http://www.excelforum.com/member.php...fo&userid=1461
View this thread: http://www.excelforum.com/showthread.php?threadid=26926