create a date range lookup datasheet

[Danin]

Hello all,

I have a worksheet that is being handled by other departments to create pivot tables between specific chosen dates that are changeable each month. This sometimes causes problems because of limited experience of the users and they will forget to return the worksheet to its original state or add calculations etc to it.

I tried creating a database, but my brain keeps thinking excel and it is not easy to retrain it.

I want to create another worksheet in the same workbook where they can go into and put a date range into 2 cells and all of the data entry between and including those dates will show up as a pivot table in a specific order.

eg:
1/2/2017 to 17/2/2017
Date /CostCode/ Resource /Total Cost

I have created command buttons before, but unsure how i would write this

 

[r2c2]

@Danin If you are using Excel 2013 or above, why not set up a regular pivot table and add time line slicer? This way, your users can interactively select the time window they want and get the report. In earlier versions, you can mimic the behavior with either slicers or date filters on pivot. If all else fails, you can use a bit of VBA to create the sub-set of data on the fly based on user inputs and refresh pivot.

 

[Danin]

thanks i am so used to writing code I never use pivot tables. will have a trial. That is lie i am using pivot tables now, but wanted something more rigid and less able to mess with.

Thanks for idea.