Velouria, thank you that's perfect!
Oh, so sorry I thought I had attached the workbook! Here 'tis...
Just spotted your article in the newsletter - that is perfect thank you!!
Oh handy! I would be looking to send as the excel file itself 🙂
That's awesome Phil, thank you for the solution (and Lajos thank you for asking the question!) I think this will be very useful. I assume that you ...
Hi Sammantha, As Mynda pointed out, it is a little tricky without an example! I had a go at what I thought you might have meant. Attached is an ...
Hello Nadia, Your Macro looks great, but there are a couple of lines causing you issues. Whilst it does successfully copy all data from bot...
Hi there, I might not have the most elegant solution, but I would suggest fixing the formulas that include the *24 multiplication as it confuses th...
Hi Matthew, Let's just break down this formula so I can understand a little better... =IF(G1 (a date on the current sheet) is greater than AF4 (...
Hi Lani, You have mentioned that the table with the sales data will be 'reset each month'? This means that a formula pointing to your January colum...
Fantastic, well done!
Hi Ken, Looking at the attachment, you still have 5 weeks listed on the sheet and so when you drop down, say, October the sheet would allow you to ha...
Hello CJ18, I had a look and I cannot see a problem with the formula. If I go down to line 195 and change the date for Employee # 16ZAH so that they ...
I often choose to use standard basic formatting to make things clear to the end user. In the attached I have used gentle shading across the entire she...