multiple results of rows and columns from different tab

[abusarah]

hi
here ive uploaded a file called "practice excel".
what im trying to do is generate the purchases i made from the seller to the table below it. i ve put a drop down box for the seller, so i can select the seller i want. i ve three tabs; purchase bill, purchase bill details, and store details.
the results shoud be coming from the "purchase bill details" tab. and if there are more than one purchases from one store all results should be pulled in a descendind order by default.
tried a lot but couldnt seem to do it right as im a beginner.
thanks and a detailed follow through would be highly appreciated

 

[pecoflyer]

Perhaps try a Pivot Table?

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[abusarah]

Hi ,

See if this is OK.

Narayan

thanks. thats pretty much what i wanted to do. and your formula seems to be going the same way as i went. now i have it, ill compare and see what i did wrong on my other file.
you are great.