Summary:
1) Look at pic
2) I hate having entering data into excell + scrolling 10 pages horiz.
3) Recommend an alternative pls
Picture of Excell Spreadsheet
Long:
Boss wanted paper contracts on the computer asap...this was the first thing I could think off. The list is now nearing 400 contracts and has been expanded to include customer address, phone, and a few other fields.
It's a pain in the ass to use this excell sheet but it's not me I'm worried about, it's the other people. I'm the only guy that puts this into the computer but he needs someone to do it when I'm not there (like when I go to school for half the day). Need something simpler, user friendly.
My question: What could I do to make this process more efficient?
My friend was thinking I should make a VB interface that I could _easily_ use this enter all this data rather than having to scroll 10 pages horizontally.
I used excell cuz I'm not a programmer and it was the fastest thing I could think of that had a sort and find feature which I use a LOT.
Any ideas? Would it be to hard to learn how to use VB to do what I want? Would using Access or maybe Quicken/Quickbooks be easier?
I'd be willing to recreate the database from scratch if needed, but i'd rather keep the existing data as it is and be able to enter new contracts, and edit/update what's there now (like customer payments on their dues).
edit: Maybe something like this
Pic of VB Interface
It has no code to interact with the Excell spreadsheet though. (which is what i'd need to learn so I could sort/find/save/del/etc.)
Any recommendations?
1) Look at pic
2) I hate having entering data into excell + scrolling 10 pages horiz.
3) Recommend an alternative pls
Picture of Excell Spreadsheet
Long:
Boss wanted paper contracts on the computer asap...this was the first thing I could think off. The list is now nearing 400 contracts and has been expanded to include customer address, phone, and a few other fields.
It's a pain in the ass to use this excell sheet but it's not me I'm worried about, it's the other people. I'm the only guy that puts this into the computer but he needs someone to do it when I'm not there (like when I go to school for half the day). Need something simpler, user friendly.
My question: What could I do to make this process more efficient?
My friend was thinking I should make a VB interface that I could _easily_ use this enter all this data rather than having to scroll 10 pages horizontally.
I used excell cuz I'm not a programmer and it was the fastest thing I could think of that had a sort and find feature which I use a LOT.
Any ideas? Would it be to hard to learn how to use VB to do what I want? Would using Access or maybe Quicken/Quickbooks be easier?
I'd be willing to recreate the database from scratch if needed, but i'd rather keep the existing data as it is and be able to enter new contracts, and edit/update what's there now (like customer payments on their dues).
edit: Maybe something like this
Pic of VB Interface
It has no code to interact with the Excell spreadsheet though. (which is what i'd need to learn so I could sort/find/save/del/etc.)
Any recommendations?
