Hello all!
So my current situation is as follows. For our file tracking, we use an excel file with a few columns: Book Number, Date, Book Title, Client, and Banker. Book number is simply sequential, so when someone asks me for a new number, I give them the next number in the list and fill in the relevant data after it.
We have multiple offices, so what we'd like to do is post a form on our company intranet that feeds off of this excel file, so basically, something like:
Once they hit submit, the data is entered into the excel file, and returns to the form the number they should use.
I'd also like to have a form where bankers can do a search, either by number, date range, or text string (which would search the book title), and return results. Is this possible?
Hopefully one of you excel wizards can help me out, as this is beyond my scope. Many thanks in advance!
Bookmarks