I had a program at my former job that had a check registry on it. When there was a new "vendor" or recipient, they had to be issued a category automatically. I could look up by check number, by vendor name, date of check, or category. Can I do that with ms office excell? Or is there software I can download free to do this?
2006-07-16 18:38:21 · 4 answers · asked by melarkie6364 1 in Business & Finance ➔ Personal Finance
You can do this with excel.
Just have column headings like check #, date, recipient etc.
You can also add categories by making drop-down lists or v-lookups.
You can either sort them every time or do an auto-filter by highlighting the heading row and hitting data, filter.
Click on the arrows that appear at the right of each box to filter out the ones you want.
To see all of them again, remember to click on any blue arrows and select 'all'
If you choose not to filter, ctrl+f will let you search by any text you want.
2006-07-16 18:45:24 · answer #1 · answered by Beth 3 · 0⤊ 0⤋
I use Microsoft Money program at home. I can look up many different ways. I am pretty sure you can do the same thing with Excel.
2006-07-17 01:42:12 · answer #2 · answered by jennifersuem 7 · 0⤊ 0⤋
Intuit Quicken is your best bet. Not free but an excelleng piece of software.
2006-07-17 01:41:57 · answer #3 · answered by bufferedbrain 2 · 0⤊ 0⤋
i don't know if Excel does this.
QUICKEN does. it isn't usually free.
2006-07-17 01:42:27 · answer #4 · answered by nickipettis 7 · 0⤊ 0⤋