Forum Discussion
Lookup/Autofill function
mathetes Just looking to fill a sheet with vendors every week that we paid. So this week I paid 20 different companies. Next week I paid 30.......some the same as last week. Just the name on the sheet and that is it. I just don't want to have to keep typing every single vendor name each week on a spreadsheet. If there is an auto fill or something....
If that's really ALL you're doing, just a list of names and you start over each week with mostly the same names, then a simple solution is to keep it all on one sheet. Excel is generally "smart enough," when you're using a lot of the same names (same texts) and repeating them in the same column, to prompt you with the complete name once it recognizes a unique set of letters. Try it.
And you can just enter the week (the monday or friday of whatever) once and copy to the other entries for that same week.
But just to underscore here, you're really not using Excel for any special purposes, using any of its data analysis purposes or anything like that, right? If you are, if at the end of the year you want to know how many times you'd paid "Pepsi" for example, we'd possibly want to get more sophisticated.