| Trusted Advisor with 4,769 posts. | | Join Date: Mar 2008 Location: Oegstgeest, The Netherlands Experience: Advanced |
13-Jan-2011, 07:49 AM
#16 |
I did some coding a reproduced your Reulsts screen in the form of the pivot table.
Just double click on cell B1 of Sheets Results to refresh.
Condition is that the Data sheet starts on row 6 with first entry on row 7 or 8 as is now.
It was just fun to do.
The table will expand or reduce denpending on the number of month's and therefore also the text in the last column
8-months 6-months whatever applies.
It was just fun to do, and like I say, I like the 'brain gymnastics' 
__________________ Cheers,
Hans It's all in the code... and may the code be with you! If it isn't . . . start debugging! ( Time zone: Western Europe) |