Forum

Well, there is a cure for that. At Workbook_Open, a code can unhide the necessary sheets, only if macros are enabled. If not, users will see just a...

Matthias said A disadvantage of using UDF could be that you have to have the content activated and by default it is deactivated. Correct? So I stil...

Check your excel updates also, maybe you hit an old solved bug, who knows. I noticed that your loaded query s not looking right, but when I apply t...

Catalin Bombea said Hi Todd, Check the PDF Name, it's in these lines: 'Current month/year stored in M1 (this is a merged cell) Curren...

Hi Matthias, Do you have the same filtering issues on the sample file you sent? I as not able to reproduce the issues you described, no matter how ...

Hi Todd, Check the PDF Name, it's in these lines: 'Current month/year stored in M1 (this is a merged cell) CurrentMonth = Mid(ActiveS...

Hi Matthias, The alternative solution depends on those sumifs you are talking about. But most probably will be a simple pivot table that can count ...

Then it will work with what you already have, no need to change anything. I don't see why you need another way of checking the email from E1, the exis...

Hi Anne, Can you please prepare a sample file with your tables? You mentioned that a contract is usually 12 months, is this information in one o...

Practically, that's what it says already: if an email is entered in E1, the length of that cell's text will be greater than zero. I can guess what'...

If the column name contains special chars that may break the M query language, the header is converted to a text string with this pattern: #"Header te...

Hi Todd, Paste the code into the same module where your other code is, or even into a new code module, does not matter. Looks like the browser c...

Always select the column from the right side list of columns and double click on it to use it in formula. You'll see the difference. You can even see ...

You can handle null values in formula: = if [#"ID #"]<> null then (if Text.Contains("95053, 96354, 96481",[#"ID #"]) then "2000I" else [Finan...

Here is a step you can add before grouping: = Table.AddColumn(Source, "New Finance Code", each if Text.Contains("95053, 96354, 96481",[#"ID #"]) th...