ExcelBanter - Pivot Table & Template Help

ANYONE WANT A CHALLENGE?

Can anyone help please? I need help from someone who has knowledge
about pivot tables and, or, templates.

I have a large worksheet of data that is imported into excel every
Monday morning. This has been fine so far but now my boss wants a pivot
table creating for certain columns and then this to become a template so
every Monday morning after importing this data it can just be dropped
into the template. Can this be done? He also wants some more columns
added to calculate averages in the data and one calculation to involve
time, ie how many months has passed since the start of a contract and
how the contract is performing. If anyone thinks that they may be able
to help in ANY way PLEASE contact me at my private email address which
is and I shall email you the spreadsheet
concerned with more details. I have to do it this way because this
program will only allow a 100kb file for upload and the file is 622kb.
I know bosses don’t ask for much do they. :mad: I would appreciate any
help on this he is expecting some results this coming Monday HELP!!!
It looks like I shall be on here again in 3 hours from now (8pm UK
time) and staying on here all night and all day Sunday trying to sort
out this mess. so if anyone needs to go live or leave me messages
please feel free.

--
GKS
------------------------------------------------------------------------
GKS's Profile: http://www.excelforum.com/member.php...o&userid=32815
View this thread: http://www.excelforum.com/showthread...hreadid=528864