I can work on this tomorrow if you pay the fee into the site and send me your instructions.
I designed dashboards, reports and spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites, with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting, and I have made many workbooks that record the volume and product bought from suppliers, the stock you have in store, and what you sell each day.
You have not said what program you use to record the Sales Data that you want entered into Excel? My suggestion is to convert the data into a CSV file. I will then provide a Macro that adds the new data into the workbook every day AND gives you summaries of the receipts, stocks and sales.
I am happy to send you an example of my work to let you judge my Excel skill for yourself, but the site requires you to send me a Private Message before I can send you an attachment,
Hope you find this of interest and look forward to hearing from you
Bob Allen-Turl