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!!
