How to link 4 list boxes

[Shilpa kanchan]

In sorting sheet when i select the 4 list boxes, that particular data will be displayed based on data sheet

[Shilpa kanchan]

is it very difficult

[Ace_XL]

Using SUMIFS..see attached Cell C10

[Shilpa kanchan]

Tkank you.. but I dnt want the total of particular Party.

for eg : when i select India, AM, 2012, Aug.. that result wil be

Inv Date Weight
2-8-2012 6256
20-8-2012 16910
23-8-2012 17030

[Ace_XL]

In C8 of Sorting Sheet use =MATCH(B8,P2:P13,0)

and try this..

Please Login or Register  to view this content.

[Shilpa kanchan]

can't I use any excel formula

---------- Post added at 04:34 AM ---------- Previous post was at 01:55 AM ----------

[martindwilson]

here you go helper column in data sheet column F you can hide that or even put it on another sheet completely