modifying code create summary customers based on column sheet to multiple sheets

hello
first of all i would thank M.r Jindon & Maniacb about your codes and solved for earlier my post in this link
https://www.excelforum.com/excel-pro...ml#post5424988
so if is possible amending code by search in multiple condition and show in the searching sheet only result1 (note: result2,3,4 just to understand what I'm looking for with ignore create sheets of customers
condition1 in sheet result1 if I select name from n3 and no dates
condition2 in sheet result2 if I select name from n3 and date in o4 & p4
condition3 in sheet result3 if I select all without date
condition 4 in sheet result 4 if I select dates and empty n3
condition 5 maybe is complicated if is not possible ignore it I would create report all customer in one page sheet2 to print it
i know this is very huge demands i hope read my post and help me
thanks i

See if this is how you wanted.
Since I had no time to test the code in much different combinations of the criteria, it might have bugs, so report back.

Please Login or Register  to view this content.

hi, Jindon I tested the code , but there are many problem first when I select date from tool calendar it gives me error in this line

HTML Code: 

error application-defined or object-defined
the second when I search name bring data without balance first of duration from sheet "balance first of duration" as in the original code , but when i select all add it without account in the lastrow to be matching with cell L3

That was the one I don't understand what kind of data will be entered from Calendar.

I manually entered the dates in both cells.

just when i DoubleClick it shows me calendar and I choose day then insert whole date into cell , even write manually the dates still show the error

still some problems in values please check my file I put some comments to understand closing in sheet "result1" & result2 and if is possible about date maybe some customers have no data if I write specific from date it gives me error could you fix it
thanks

I put L3 Col.D from "balance first of duration" when the name is found.
When not just put 0 in L3, isn't it what you wanted?

it's ok the code does that what I meant it should insert from g2 every name contains that

Please check my file sheet result1 i put my imagine to understand it

Try this

Please Login or Register  to view this content.

it shows other problems if I choose dates without select name it doesn't show balance first of duration whether in cell I3 OR from row2 in cell g2 and if I write date in o4 is not existed for specific name it gives me error ,how can I fix it ,please?

well done ! you did great work it remains standard 5 i know this complicated and may be different my thread for answering it's up to you otherwise I will issue a new thread as in my post # 1 I put the result in sheet2 it depends on sheet result1 what I search then copy to sheet2 the aim for this to print the reports what I choose it

Please Login or Register  to view this content.

awesome code but seem I don't explain clearly this code apply all of data yes i wanted that but if you can make it depends on select name and dates or dates only in short word what show in sheet result1 it copies to sheet2 like data all

OK, I'll look at it late this afternoon since I'm pretty busy today.

try

Please Login or Register  to view this content.

it doesn't happened any thing in sheet2

If the attached doesn't work at your end, your EXCEL is different from mine.

astonishing code now it works as you file many thanks for your codes and your time
best regards,
Abdelfattah

hi, Jindon and sorry about comaback again if this upset you I will issue a new thread , I ask if is possible do that by userform the same all of things which you did the different show the data by userform instead of inside sheet I design the userform and the result show in sheet2 when show data in listbox based combobox is the same thing ,in short word the same thing all of thing , the different just how show data by userform
thanks again

How do user enter "dates"?

yyyy/mm/dd or mm/dd/yyyy etc.

And is this related to the code I have already posted?
I mean result1 and sheet2.

about date dd/mm/yyyy
populating data in listbox are based on sheet1 not based on sheet (result1) but way showing data in listbox1 are the same thing like sheet"result1"
stay same thing for way showing data in sheet2 when populate data in listbox

Please Login or Register  to view this content.

now I'm testing code every thing works astonishingly except one thing you seem forgot this or I don't explain clearly as I have ever mentioned when show data in listbox based on selection combobox, It supposes show data in sheet2 based what shows in listbox as what you have already posted
thanks again

another point the values in textbox(debit & credit & balance) are not matched with what show in listbox
there is something wrong from the first time the code works well when I search specific name repeatedly it happened odd thing odd every time i search name it changes the values into textbox
please check it

1) Change to

Please Login or Register  to view this content.

2) Change Worksheet_Change code for result1

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

hold on you did the code based on sheet result no this is not what I want this is my mistake I had to deleting sheet result when i attached the file and I'm sorry about it I would show the data in list box based on sheet1 like the sheet result you consider there is no sheet result

NO WAY!!!

You are asking too much.

I know Jindon from the beginning it's too much please complete your favor