create reports for clients from two sheets to sheet summery based on selected cell

[MKLAQ]

hello
I have data in two sheets I want create the reports based on dropdown in c1 to brings data for clients and summing the values also subtracting i put the result in sheet summery like example
if the explanation is not clear please inform me

[MKLAQ]

any help experts ?

[MKLAQ]

[MKLAQ]

[AliGW]

Reality check:

Post views: 103
Workbook views: 9
Extra information from you: 0
Offers of help: 0

What does that tell you? What it SHOULD tell you is that nobody can work out what you are asking, so try re-framing your question with more detail.

Of course, it could just be that members have taken one look at the series of annoyed and angry emojis and decided not to bother. Either way, your thread is getting no traction, so it's up to you to make your request clearer.

[jindon]

MKLAQ,

try the attached.

Please Login or Register  to view this content.

[MKLAQ]

@jindon many thanks for your interesting solve my post but I would that based on selected in c1 in sheet summery please could you check c1 contains many items your code should work based on c1

[jindon]

1) Summary sheet code module.

Please Login or Register  to view this content.

2) A standard code module.

Please Login or Register  to view this content.

[MKLAQ]

@Jindon wow !! you are the best many thanks for a huge assistance
just I would mod the code if it 's possible
when I select item in first time and select another I would copy to under what have ever searched
I mean every time I select it from c1 then copy under each other of them except the "all customer"

[jindon]

Please Login or Register  to view this content.

[MKLAQ]

great ! but I note if I select the same item more than one time it repeats copying I don't want repeat the item has already existed when search it just update without repeat again
thanks again

[jindon]

Then don't select the same item, until you clear the item.

[MKLAQ]

now I see it I can clear c1 then clear all and start gain to search
many thanks for your times ,codes patience