I’m trying to create an Excel data form to track expenditures by college students in over 100 campus organizations. The form would have a sequential transaction number, date, organization name, account number, fund code, cost, and item purchased. I want the data form to automatically complete the organization name after entering the first two or three characters of the name (names are unique enough to allow this) and also enter the account number associated with that name. I would also like the date to default to the current date. I would have to manually enter the transaction number, fund code, cost, and item purchased.
