Hello,
I have two listboxes , listbox1 will show all of data across sheets based on name is selected from combobox1, and match with names in column B across sheets after that will merge amounts in last column in list box based on column 5 in listbox1 for each duplicates items
the items based on column (4) in listbox2 should show like this("Futures purchases","Futures Returns purchases","Futures Sales","Futures Sales Returns","Bank withdrawal","Cash withdrawal","Bank deposit","Cash deposit"). as to NET row in listbox2 the formula should be (Futures purchases+Futures Returns purchases-Futures Sales+Futures Sales Returns-Bank withdrawal-Cash withdrawal+Bank deposit+Cash deposit)
here is data
when select name from combobox the result will be
when select name from combobox1 and dates in textbox1,2
if the combobox1 , textbox1,2 are empty then will brings data for all of names in listbox1 and merge for all of names in listbox2
if combobox1 is empty and texboxes are filled dates then brings data for all of names within two dates in listbox1, and merge for all of amount for all of names in listbox2.
if it's not clear I will post more pictures
last thing I have big data for each sheet contains 11000 rows .
thanks
I have two listboxes , listbox1 will show all of data across sheets based on name is selected from combobox1, and match with names in column B across sheets after that will merge amounts in last column in list box based on column 5 in listbox1 for each duplicates items
the items based on column (4) in listbox2 should show like this("Futures purchases","Futures Returns purchases","Futures Sales","Futures Sales Returns","Bank withdrawal","Cash withdrawal","Bank deposit","Cash deposit"). as to NET row in listbox2 the formula should be (Futures purchases+Futures Returns purchases-Futures Sales+Futures Sales Returns-Bank withdrawal-Cash withdrawal+Bank deposit+Cash deposit)
here is data
omrany.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | DATE | NAME | INVOICE NO | CONDITION | AMOUNT | ||
2 | 01/01/2024 | Ahmed | VN number 345666 | Bank withdrawal Ref No 7890 | 3,000.00 | ||
3 | 02/01/2024 | Ahmed | VN number 345667 | Cash withdrawal VCF NO 789000 | 2000 | ||
4 | 03/01/2024 | Ahmed | VN number 345668 | Bank withdrawal Ref No 7891 | 1200 | ||
5 | 04/01/2024 | Ahmed | VN number 345669 | Cash withdrawal VCF NO 789001 | 1300 | ||
6 | 05/01/2024 | Hamuda | VN number 345670 | Futures purchases inv no 23444 | 2200 | ||
7 | 06/01/2024 | Hamuda | VN number 345671 | Cash withdrawal VCF NO 789002 | 3400 | ||
8 | 07/01/2024 | Ahmed | VN number 345672 | Futures purchases inv no 23445 | 3500 | ||
SA |
omrany.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | DATE | NAME | INVOICE NO | CONDITION | AMOUNT | ||
2 | 01/01/2024 | Ahmed | VN number 345666 | Bank deposit Ref No 7892 | 3,000.00 | ||
3 | 02/01/2024 | Hameed | VN number 345667 | Bank deposit Ref No 7893 | 2,000.00 | ||
4 | 03/01/2024 | Ahmed | VN number 345668 | Cash deposit VCF NO 789003 | 1,200.00 | ||
5 | 04/01/2024 | Hameed | VN number 345669 | Cash deposit VCF NO 789004 | 1,300.00 | ||
6 | 05/01/2024 | Ahmed | VN number 345670 | Futures Sales inv no 23446 | 3,000.00 | ||
7 | 06/01/2024 | Hameed | VN number 345671 | Cash deposit VCF NO 789005 | 2,000.00 | ||
8 | 07/01/2024 | Ahmed | VN number 345672 | Futures Sales inv no 23447 | 1,200.00 | ||
VS |
omrany.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | DATE | NAME | INVOICE NO | CONDITION | AMOUNT | ||
2 | 01/01/2024 | Ahmed | VN number 345666 | Cash deposit VCF NO 789005 | 3,000.00 | ||
3 | 02/01/2024 | Ahmed | VN number 345667 | Cash deposit VCF NO 789006 | 2000 | ||
4 | 03/01/2024 | Ahmed | VN number 345668 | Bank deposit Ref No 7893 | 1200 | ||
5 | 04/01/2024 | Ahmed | VN number 345669 | Bank deposit Ref No 7894 | 1300 | ||
6 | 05/01/2024 | Ahmed | VN number 345670 | Bank deposit Ref No 7895 | 2200 | ||
7 | 06/01/2024 | Ahmed | VN number 345671 | Futures Returns purchases inv no 23446 | 3400 | ||
8 | 07/01/2024 | Ahmed | VN number 345672 | Futures Returns purchases inv no 23447 | 3500 | ||
9 | 08/01/2024 | Hameed | VN number 345673 | Futures Returns purchases inv no 23448 | 3501 | ||
10 | 09/01/2024 | Hameed | VN number 345674 | Futures Returns purchases inv no 23449 | 3502 | ||
11 | 10/01/2024 | Hameed | VN number 345675 | Futures Returns purchases inv no 23450 | 3503 | ||
12 | 11/01/2024 | Hameed | VN number 345676 | Futures Returns purchases inv no 23451 | 3504 | ||
AP |
omrany.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | DATE | NAME | INVOICE NO | CONDITION | AMOUNT | ||
2 | 01/01/2024 | Ahmed | VN number 345666 | Bank withdrawal Ref No 7892 | 3,000.00 | ||
3 | 02/01/2024 | Ahmed | VN number 345667 | Bank withdrawal Ref No 7893 | 2,000.00 | ||
4 | 03/01/2024 | Ahmed | VN number 345668 | Futures Sales Returns inv no 23447 | 1,200.00 | ||
5 | 04/01/2024 | Ahmed | VN number 345669 | Futures Sales Returns inv no 23448 | 1,300.00 | ||
6 | 05/01/2024 | Hamuda | VN number 345670 | Futures Sales Returns inv no 23449 | 3,000.00 | ||
7 | 06/01/2024 | Hamuda | VN number 345671 | Futures Sales Returns inv no 23450 | 2,000.00 | ||
8 | 07/01/2024 | Hamuda | VN number 345672 | Futures Sales Returns inv no 23451 | 1,200.00 | ||
SSC |
when select name from combobox the result will be
when select name from combobox1 and dates in textbox1,2
if the combobox1 , textbox1,2 are empty then will brings data for all of names in listbox1 and merge for all of names in listbox2
if combobox1 is empty and texboxes are filled dates then brings data for all of names within two dates in listbox1, and merge for all of amount for all of names in listbox2.
if it's not clear I will post more pictures
last thing I have big data for each sheet contains 11000 rows .
thanks