I need help building some pivot tables for my spreadsheet.
I have built a spreadsheet which runs our business - it follows the process of the business & all the sub contractors that we use for each project, it contains over 100 colums of data which track:- dates, companies., prices etc. I need to cut the data in about 8/9 different views to show:- what jobs are happening by wk, which contractors are doing what projects, whihc jobs have bee invoiced etc etc.
I have very limited experience of pivot tables & at the minute are copyin g& pasting data onto differnt worksheets - whcih is time consumin g& we're making mistake.
Id like all this linked up & automated & potentially a 2nd project to drive reportin g& analysis.
Pls email me if you think you can help