Forum Discussion
Pivot Tables
I'm building a Pivot table from the data shown below. It's energy usage data at 30min intervals. Column C is the intervals; half hours & hours. Column F is the kWs. When the Pivot table is created fr...
Hi Guys, I have a workbook with 12 sheets, one for each month. The sheets are based on the UK tax year and month, so that the first starts (Sheet 1) runs from the 6 April to 5 May and so on. On a separate sheet I want to gather data from the same cell on each of the 12 sheets but only the most up to date sheet. So if it was the 12 March 2021 it would show me data from sheet 12. I assume that using the TODAY() function would provide the most accurate method but I am struggling with this one. I would add that the workbook would only be used for a year and another created for the next year and so. Can you help?
What your are doing is called Threadnapping.
Please delete your post and start a new thread.
