can you put the info from sheets 1 and 2 onto one sheet only, by
putting jacks shop, freds shop etc in column A, putting facs flex study
etc in col B and reserving columns C onwards for april may june etc
data???

shop type april may
jacks shop facs 33 44
jacksshop study 7 6


if so you could have a sumproduct summary sheet on another sheet that
would update in real time.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=557754