Creating Weekly/Monthly Sales Report

[abac]

Hello expert,

I have attached a spreadsheet - I'm trying to create a weekly/monthly sales report in Excel and I have been spending hours on it to create it. So far I have created some but it looks very clunky and doesn't look attractive/user friendly or easy to browse especially the sheet view changes on different size screens. Also the button on the sides look a bit rubbish. I have learnt a lot from you and I know you guys are expert. Please can someone look into designing the sale report which looks decent and better coded and add formula in it.

The report will have 12 businesses with 1 board report so in total 13. If the board report can have pivot table just to provide overall data for combine business or individual data would be benefit.

I would really appreciate your help and guidance on this.

Many thanks,

[abac]

Anyone please help

[AliGW]

Administrative Note:

We don't expect you to bump threads more than once in 24 hours - it has been only a few hours since you posted and it’s a Bank Holiday weekend here in the UK. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[FDibbins]

Also, Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[abac]

Thank you - I have amended the title

[abac]

hi folks,

Please can anyone give me any idea and I can take it from there. I'm just looking for tiny bit of help please.

"The idea is not to push the post up, so please admin don't tell me off. I'm just in need of help."

Many thanks,

[JeteMc]

Looking at the 1...12 sheets my idea would be to put the input into tables in record format.
By record format I mean: Date Sales manager/Sales consultant # of Clients
You could Then avoid some of the formulas like in cell AD10 and use COUNTIFS i.e. =COUNTIFS(B14:B1000,AD5)
Similarly you could use a SUMIFS formula in AF10. (Another idea would be to not use merge and center cells)
Once done you should be able to use the 2016 version's Get & Transform to combine the data from the 12 tables into an appended data table or the Data Model, depending on how much data is involved.
Let us know if you have any questions.