INDIRECT - Referencing Dates - Urgent Help Needed..

[janinereynaldo]

Hi Guys,

I'm currently working on a sales dashboard and I badly need your advise.

I'll to explain it as much as I can so you can understand and visualize it.

Each salesrep has their own sheet to fill up. Formats and headers are same for all. Like this:

Capture11111.PNG

I wanted a summary sheet wherein I can select a particular MONTH and SALESPERSON in a drop-down list and the data will show.

My summary sheet looks like this:

Capture123.PNG

I was able to get the data, AMOUNT and PROBABILITY, from the selected SALESPERSON's sheet but what I can't do is to get the SUM of those amounts as per the dates above them (Weekly Sales).

Apart from that, if I select "ALL", how am I supposed to get the SUM of all the sheets?

Capture234.PNG

I'm really hoping someone can help me on this.

Thanks in advance!

-Janine

[JohnTopley]

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.