Okay, I understand. Your buyer will be a single person and if some else uses the file it will not work. I understand. If you send me a PM with y...
Unless, IF the OP is using 365 or (2021 for some limited new function) then the extra XLOOKUP can offer a solution
Okay, it's clear and what goes for the Excel versions many things can be done but then again what do you see as safety measures? User level access ...
Security is something that can be hacked. You have not told us if the templates are macro embedded which version of Excel you're using, etc. I have...
Hope the OP agrees too
This is the one causing the error (D1="LEAVER",EOMONTH(D2,-1)+1=D2) I think a missing ) IF(D1="LEAVER",NETWORKDAYS(EOMONTH(D2...
You're welcome, there may be other options for sure but this would be the away I'd do it. Happy coding
What you're explaining hasn't ocurred to me except only if you have macro code that triggers an action like worksheet activate or deactivate or simila...
Then try this
Try this: Paste this code in the worksheet replacing your own code Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Ran...
Since you have this macro and it works I suggest you do the following. Start the macro recorder. 1. select the table or are 2. set Sort from the me...
Hi Sherry, Give this a try Sub FilterRowsOwner() ' Sheet = "Owner_CAPA", Column = U/#21 Select case Worksheetfunction.CountA(Worksheets("Ow...
May I ask why the conten of column B is a formula (="SR911") and just SR911? Many other cells have formula's where maybe you wanted text. If you...
Hi Dom, First I think you should mention the version of Excel you're using for this. The reason is that as of Office 365 many new funtions have ...
I've got the pictures but the file refers to a pivot table whihc is not available. Sorry for that. No help from this side