thanks,

the raw data is pasted into a worksheet inside the template and the
records are filtered using the "Sumproduct" function.

i.e
=SUMPRODUCT(((RawData!$C$2:$C$20000=$B$2)*(RawData !$K$2:$K$20000=D$1)*(RawData!$G$2:$G$20000=$C2)),R awData!$P$2:$P$20000)

basically it searches through the records to find entries that match
the criteria.

D$1 references a cell with a date in it, in the UK format, dd/mm/yyyy.

the data pasted into the template is always UK format (dd/mm/yyyy).


i need them to always stay in dd/mm/yyyy format regardless of what the
user has there region set to.


--
jarvo
------------------------------------------------------------------------
jarvo's Profile: http://www.excelforum.com/member.php...o&userid=18983
View this thread: http://www.excelforum.com/showthread...hreadid=395748