Input$ Userform
I created a multi-page (4) userform and need help coding. When user enters
invoice number and tabs or enters, the form searches all forms for the
invoice number. If there is a match, then the status is updated and
effective date entered, if the number is not found, a new record is added to
the appropriate spreadsheet. The goal is to create a userform that sorts
data based on type and month. This multi-page userform will sort and update
data for about sixteen forms. If I can narrow down the entire load to just 4
worksheets and use the report manager to sort data by month, that will be
great.
Please help
|