Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Help Creating Report


Hi guys, i wonder if you can help me - a bit of background first though. I work for a retail company that uses a lot of contractors in their shops to cover when someone is off on holiday or sick or such. Part of my job is downloading an excel report that has a list of dates when the shop needs cover, which i then i have to go through and identify 'blocks' where we have multiple uncovered days clumped together and then book a contractor to cover those days. Is there a way to get excel to autolook through the dates and just highlight any blocks of say 3 or more days that are bunched together, then on a seperate page of the workbook output it along the lines of:

London Store - 23/05 to 27/05 - 4 days required.

I appreciate that this might not make sense, or is an extremely easy/beginner question but any help would be greatly appreciated.




Hi Boonk and welcome to the Forum.

Suggest you look at Don's tutorial onĀ SUBTOTAL Function - Work on Filtered Data in Excel. You should be able to use that yo crw=eate the sums you need.

Othewise, please edit your question and use the Add Files... button to upload a representative Excel file (without any personal data) to show your existing macro and data. Then we should be able to give specific help



Hi Boonk,
Reading through your post this seems like it should be fairly simple to solve, but without a sample file it is impossible to do so. Just as John mentions, use the "attach files" button to include a sample file of the Excel report which you download, so we can see how the information is listed as this is key to providing you with a solution. Also, do you only need to know the number of days that need to be covered or do you also need to know how many peoplle per day?
WillieD24 (rep: 130) May 7, '22 at 9:20 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login