Forum

Hello, I am no coder myself but it seems to me that this article is describing what you are looking for, on how to set up a drop down list allowing...

Hello, Welcome to MOTH! Thanks for the sample file, it makes it far easier to understand the issue and to find a solution. I understand it that ...

Hello, For the summary part you can use SUMPRODUCT. If you want this data in a PivotTable then you need to rearrange the source data to be in ta...

Hello, I assume you enter a value in cell 'DRS - VARIATIONS'!C6, for example VO1 and that triggers fetching of data from tab VO1, is that correct u...

Hello Jan, Welcome to MOTH. If you had read the forum rules you would have noticed that is expected to upload a sample file with relevant data. You...

Hello, Great that it works as you wanted. Br, Anders

Hello again, While trying to get to sleep I was actually able to think of a way to only get those values that belongs to the picked Cause, FC_High ...

Hello, I never said it would be easy to set it up, but see attached file for an example. You can add more data to the table and it will pick up ...

Hello, One can tell you have not glanced at the forum rules, if you had then you would know that uploading a sample file is a good way to get respo...

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...