Last seen: Jul 6, 2025
Hello, Depending of what version of Excel you have, below are examples of how to set up dynamic data validation lists. Excel 365 Dynamic Depende...
Hello, Have you tried with using the PROPER function? It will not work correctly with the state abbreviations though, as you probably want those in...
Hello, I think you would be better off using Power Query, but that is just an assumption, I don't know how your data is. As you have noticed alr...
Hello, Better yet to avoid such scenario. Can’t you either use drop down list values or store id instead? Br, Anders
Hello, As you write ”… update all tables …” I assume you can succesfully update each query individually, or does it fail there too? Without a file ...
Hello, Seems the file didn’t get uploaded. Looks like you want to build dependent data validation lists, see if this article can help you forwar...
Hello Andy, I am no coder, but what you are trying to do requires only basic knowledge of VBA. I do think you want to spend some time and learn the...
Hello, I don’t really follow along with what you want, there is no such thing as 50 minutes hour. What is the usage of such formula? What does it n...
Hello, Have you tried to record a macro? It is good start to get the code created by Excel for each step. How to record a macro in Excel Br, ...
Hello, You can of course record the steps and let Excel create the code. How to record a macro in Excel Br, Anders
Hello, What is the logic behind these colours? Why do some cells get dark grey and others light grey and some no colour at all? These colours are s...
Hello, One way to bring out the Branch is like this. In Power Query Editor; Go to Add Column menu tab and choose Conditional Column. Name thi...
Hello, It would be much better if you upload sample files containing the data. Where do you get stuck? In other words, what have you tried to do? T...
Hello Julie, Your file contains lots of data and I have not yet fully understood what is happening in the file. I take it that it is kind of an inv...
Hello Vincent, Might be that you refer to the old XLM macros used before VBA, there is an article about it that could be of interest. There you hav...