Forum

You can open the excel file with 7Zip, or winRar, or any other archiver, then go to xl folder->worksheets. In worksheets folder, you will see multi...

Hi Ivica, It's a power query solution, it's in the sample file attached to my previous message All you have to do is to fill the table with your ma...

Hi Ivica, It's much more easier in Power Query than vba, just Unpivot Prio columns then Pivot the new column created. let Source = Excel.Cur...

Hi Sal, The file from the link provided does not contain the code you described. Use shtBDP.ListObjects("tblSampleDay1F1") reference to make sur...

Hi Jim, Everything in Power Query is in M language, not sure what your question is about. The only difference is that some of the operations are ex...

Use the Extract first character function on the first column, not the tables column... Then change the column name and the function used in that st...

B12:H13="y" will produce an array of True and False values, there will be one true/false value for each cell in the range. If you divide the next ...

If you move up one step, you will see that the grouping step created tables in the second column. You will notice that those tables from the second co...

Hi Pavel, Try the attached file. The query looks like this: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Renamed Column...

Hi Anil, Try: =SUMPRODUCT(IFERROR((C12:I13)/ (B12:H13="x"),0)) =SUMPRODUCT(IFERROR((C12:I13)/ (B12:H13="y"),0))

There is a double click event used in that code you have, but it should be removed because it will always write to active cell, you have no control of...

Hi Robert, Should be >Frame1.Caption, not .Value The .Value property an be used in textbox, combobox, checkbox, but in labels, frames, use .C...

Hi Mike, A simple search after "ODBC tracing" will reveal this tutorial: You can also use the search tool in our computer, for "ODBC Data Sources...

Hi Laura, welcome to our forum. You can put that code in a new module, or in the same module where the create_and_email_pdf procedure is located...

Hi Ju, Why are you saying that [A] is excluded? Not seeing anything doing that in your query, it will just convert any column to type number, inclu...