Forum Discussion
How to Compile Data More Efficiently
Hello! Need some help from an Excel wizard!
I need to pull our restaurants sales data by menu item so we know what was sold on a daily basis and can reconcile this against our inventory counts. I can pull the report in our system. However, what I am doing now is putting each day on it's own sheet since the data isn't going to be the same each day. For instance, we may sell crab legs one day but not another. For ease of analysis, it would be great if I could get it all on one sheet. But I can't figure out how to do it without entering the data manually, one menu item at a time. Is there an easier, more efficient way to do this? I'm attaching a file so you have an example.
I'd appreciate any help I can get with this!
TIA!!
- Those tabs in your Excel file, how did you get the information into them?
Does your "system" have an option to export data?
Anyway, you can paste all data below each other into one tab and then create a pivot table from that tab. Drag the Menu item to the rows section and the amount to the SUM section.
