Hi Carlos, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
Can you please send me a dummy copy of your Excel file so that I can check your spreadsheet structure and see what I can do. Regarding the "tricky part" that you described, it is not possible to do that in a single sheet. Your best alternative is a Summary Sheet or a Dashboard that will display summary information, but this sheet SHALL NOT be the same sheet where you enter your sales data.
You can use the paper clip icon to attach your dummy Excel file.
Please let me know by replying to me here so that I can help you further.
Thank you for writing back with the Excel file. Yes, that is only your best option and you cannot avoid those tabs if you want to organize your data that way.
Please give me a moment and allow me to check your Excel file first.
You're welcome, Carlos and thank you for your patience. I am now checking the structure and data of your file.