In the sheet's project code Worksheet_Change event. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("E1")) Is No...
My Online Training hub has most of the answers and works all the time. Long before I found this site I found the spreadsheet Guru with some great t...
Hi, in my honest opinion you can only do this using VBA (a macro). This macro could be triggered by a worksheet_change event or else by a button wh...
Hi, excuse my butting in 🙂 I'm not that proficient in Pivot Tables or DAX functions, but I like to play with formula's next to VBA. This is my ...
What if you tell us more first? You don't give any version information and I doubt very much that this is an Excel question
Hi, Guessing is not an option. A sample file with some non-private/non-sensitive data will make understanding and picturing your question better. D...
If you read your own code carefully, you'll see that you are searching for a sheet named 'Output' and it's really named 'output' CASE SENSITIVE !!!...
I won’t be able to help you just yet since I’m on a short vacation and no devices except my iPhone. I’ll take a look when I’m back and see how far ...
Image files show what you want but are simply not an idea of a sample file Just make sure non private or sensitive data is removed; which version o...
Just and idea: what if you add a worksheet where you have the full path set in a named range and with the new functions available in 365 list all t...
Hello Anders, Thank you again. I think I've got sufficient ideas to play around with. I'm marking your lats post as Useful Answer. Cheer...
To explain it better, if you look at the Table of the attached (Mynda's file) you can see how it's done What I need is that when the file is opened...
Hi Anders, Well, the information you attached was/is known to me but that doesn't achieve what I really want What I am looking for is that let's sa...
Thank you Anders, I don’t think this will do the trick I need but… I’ll try it later and let you know