Hello everyone,

I am not entirely new to VBA in Excel, but I am afraid that this time, IŽll have to ask for little help;

IŽve got one sheet with multiple pivot tables sourced in MSSQL. First pivot table (lets call it WAREHOUSE) is showing all stock movements (including dates) in the past - if you sum all of them from the beginning to the end, you will get current stock level. So, obviously, I need to find some way how to filter all the data which has date less than one entered in designated cell (I found out, after some research, that this could be the best, easiest and most user-friendly way) - which will show stock level at entered date.

Is there any way to do that using VBA? (havenŽt use VBA with pivot before)

Thanks a lot for any responses.