Hi looking for some help to create a table to input work receipts. See attached example. My issue is that when it comes to inputting a receipt that has multiple items on it I don't really want to put them down as individual items on individual rows with the date and the store written out 20 times for the one receipt, looking like they are individual purchases. I want items that are on the one receipt grouped together, so when I want to recall a receipt I want to be able to recall all the purchases on that receipt. EG: rows 6 to 9 on my sample table.
Last year I went through all my receipts, sorted them in date order then gave them a code number. This was very time consuming . I want to just pick up a receipt, input it into my table, then put them in date order when I'm finished.
I'm not really good at using the full benefits of excel. Any help or redirection to some help would be appreciated
Bookmarks