Use parameter for stores and retrieve month data from individual tab

[melvin]

Gday all,

I am trying to use a drill down for a particular store, where it should take data for each individual month from the respective worksheet. explaining is complex. I have attached the sheet.

i.e. As Store A is selected,
Months 1,2,3 from the respective tab should pick data for the respective store selected.

This would be gold if I could some assistance on this. Thanks all.



Melv

 

[vletm]

Use Combo box ...

 

[melvin]

Hi Veltm

I am not able to open the excel file through my phone. I will view this in couple of hours. My issue is not on creatinga drop down. It's on consolidating data for particular stores from the month tabs


Melv

 

[vletm]

.. almost same, but without Combo box.
[B1] Your store Name
[C1] Match-formula

 

[melvin]

Thanks Vltem, not sure what was going through my mind and it didn't strike me. That was straight forward.

What if I would like to sum all data for store A, keeping in mind A can be in any rows in any of those months. Can i sumif Sales, COGS etc for store A from months 1-3 ? from multiple worksheets ?

Appreciate it mate

 

[vletm]

Added total sum, A can be in any rows.
Can You send any kind of vision of You vision?

 

[melvin]

Thanks mate,

The attached file expresses what i am looking for.

 

[vletm]

... You mean something like this ...

 

[melvin]

Very unique way of getting the result , without an INDIRECT formula. Thanks mate, that's exactly what I was looking for.

Appreciate it.

 

[vletm]

.. and if more stores or/and months ... I recommend VBA.