Hello,
I have 3 worksheets: Budget, Forecast & Actuals.
I want to create a summary at the top of the Budget worksheet that allows user to select Customer/Category/Size. I thought the Slicer tool would work best but then realized I only know how to capture the data from the one worksheet.
How can I easily capture data from different worksheets with drop down option/filter?
I have attached a sample workbook.
Thank you so much!!
Bookmarks