For your info ...
Just dowloaded the file : Test Shift Sample V1.xlsm
in order test it again...and ... everything seems to function as expected
I clicked on this file and downloaded it again . Opened it and clicked on the button after enabling macros, nothing happens. It runs and stops, cells are blank. Do I need to call any procedure or something?
Looks like you do need to enable macros beforehand ...
Follow this link to learn how to make macros available :
https://www.educba.com/enable-macros-in-excel/
Hope this will help
Sorry cannot help you any further ...
Your Excel basic configuration with all Options set properly is a prerequisite for you, if you are planning to use Excel ...
Display MoreLooks like you do need to enable macros beforehand ...
Follow this link to learn how to make macros available :
https://www.educba.com/enable-macros-in-excel/
Hope this will help
My macros are enabled because I use many on a daily basis. I'm able to see the code in VB, but the result is the same when I run the code. Never happened before
Do not know how familiar you are with Excel ...
1. Instead of opening the test file from the Forum ... can you download it beforehand ...
2. Are your company 's security rules adding some kind of extra security for ActiveX ...
3. Can a colleague of yours, with a little more experience, give you a hand ...
4. Could your PC need to be more ventilation ... to become Hyperventilate 
Display MoreDo not know how familiar you are with Excel ...
1. Instead of opening the test file from the Forum ... can you download it beforehand ...
2. Are your company 's security rules adding some kind of extra security for ActiveX ...
3. Can a colleague of yours, with a little more experience, give you a hand ...
4. Could your PC need to be more ventilation ... to become Hyperventilate
I'm on a personal network, so there's no security rules blocking it. I have downloaded the file to my desktop and only then run it. Will try it on a different system and update.
Thanks for keeping me posted on the final outcome ...
Just a sudden thought ...
Are you working on a Mac ... using Microsoft Excel 2010 For Mac ... ???
Just a sudden thought ...
Are you working on a Mac ... using Microsoft Excel 2010 For Mac ... ???
No, I'm on a Windows 10 system. I copied the file to another system and checked, same result.
Also, when I tried going into the code page and run the macro, it gives me a pop-up, please see attached screenshot.
Just remove the word Private
and Run the macro ...
Among the potential issues related to your Excel configuration ...
You should have a look within VBA from the main menu : Tools>References
For some explanation :
https://excel-macro.tutorialho…raries-in-excel-workbook/
Hope this will help
Just remove the word Private
and Run the macro ...
Really sorry, but even this make it work. 
Display MoreAmong the potential issues related to your Excel configuration ...
You should have a look within VBA from the main menu : Tools>References
For some explanation :
https://excel-macro.tutorialho…raries-in-excel-workbook/
Hope this will help
I did go here, but is there any specific library I need to add because there are many that are unchecked in my VBA. In fact only 5 are checked. Attached screenshot.
Really sorry, but even this make it work.
I meant to say "didn't make it work"
Seems that I am running out of suggestions ... as to why this macro does not operate properly at your end ...
Would you mind telling me which Excel version you are using ... ???
What is your regional date format?
To be on the safe side, had already checked your regional date format ...
To be on the safe side, had already checked your regional date format ...
Thank you for that. I managed to use the formulas you first gave me to generate my report today . One small change needed in that file, can you change the ranges to entire worksheet? I tried changing the formulae but it's throwing up a #Value! error.
Don’t have an account yet? Register yourself now and be a part of our community!
