hassan1960
New member
- Joined
- Feb 1, 2013
- Messages
- 17
- Reaction score
- 0
- Points
- 0
i 2 problem and i will be happy if some one could help me thanks
1-
i have account payable worksheet which every month one new page create automatically with table of 50 rows and (A to H) column. on top of that i have one page for account receivable and one page for account balance. all of them works.
what i want is one page for search individual person. in this page when i insert the name in the text box or inbox i need the all the record of that person from all the page appear. under column name
Page name, First name, Last name, Check #, date
2-
in each page i have check number and i do not need the duplicate number. when the i enter the check number the system has to check all the work sheet from last month and this month to make sure the number is not duplicate check number
thanks very much
the project is include View attachment hassanPayable.xlsmView attachment hassanPayable.xlsm
1-
i have account payable worksheet which every month one new page create automatically with table of 50 rows and (A to H) column. on top of that i have one page for account receivable and one page for account balance. all of them works.
what i want is one page for search individual person. in this page when i insert the name in the text box or inbox i need the all the record of that person from all the page appear. under column name
Page name, First name, Last name, Check #, date
2-
in each page i have check number and i do not need the duplicate number. when the i enter the check number the system has to check all the work sheet from last month and this month to make sure the number is not duplicate check number
thanks very much
the project is include View attachment hassanPayable.xlsmView attachment hassanPayable.xlsm