Dave has attended:
Excel Intermediate course
Project years.
Hi,
I have a data table that gives me;
1. original Start date.
2. New start date
2. original End date.
4. New end date
I want to produce an auto update report table that shows me.
Name of Project and what year it was originally in and what year it is in now to show changes.
Just a simple table for each year.
Thanks
RE: Project years.
Hi Dave,
Thank you for the forum question.
I am sorry that you have waited a long time to get an answer.
You can achieve what you want in Pivot Tables if just want them organised in annual tables.
But everything in Excel is a question about how your data are organised.
If it is possible you can send me your file and I can have a look at your data and come up with the best solution.
Please send the file to:
info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Project years.
Hi Jens,
Hope everything is good with you during these............interesting times.
Is there a way of sending you my data table (email address) that I could send it to?
Dave
RE: Project years.
Hi Dave,
You can send it to:
info@stl-training.co.uk
regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
