Forum

Hi Adriano, Let's look closer at block 1 and 2 in your example: -in block 1 you have 1 NC, and the code is supposed to add 1 row below the NC, A...

Hi Adriano, Can you please upload a sample file with a manual result showing how the blocks should look like based on the block description you provid...

Hi Matthew, The userform should not write into the calculated column, it should write instead into an additional column, that must be handled in th...

Hi Jayne, In AV29, try this formula: =IF(OR(S29<=1000,ISNUMBER(MATCH(L29,{"Art Therapy","Dietetics","Music Therapy","Occupational Therap...

Sure, you can use List.Buffer on IDList and Emails lists, it should speed up processing.

Hi Jayne, Can you please upload a sample file with your data structure? Will be easier to understand your scenario and build a functional formul...

Hi, Attached is an example, change the date as needed.

Hi Rachel, Check the attached example, hope this is what you wanted.

Hi Tanya, Here is the one step you wanted: Custom1 = Table.FromRecords(Table.TransformRows(#"Changed Type",(rec)=>Record.TransformFields(...

Hi Anthony, Results is a listbox object, if the code does not recognize it, you might have deleted it or renamed. See image attached. To attach...

Hi Anthony, Can you please give us a clue to understand to what code you are referring to? A sample file with your code will be the best idea, this wa...

You can use this structure: If Target.Row = 1 Then Exit Sub If Target.Cells.Count > 1 Then Exit Sub Application.EnableEvents = False Dim ...

Hi Lea, Not sure I understood where you want to put the buttons? I have a file with 4 sheets, I want to add in them the transition buttons bet...

Hi Isaac, Instead of: sh.Copy After: = Workbooks(strDestName).Sheets(1) Use: sh.Copy After: = Workbooks(strDestName).Worksheets.Count 'dependin...

Hi Sherry, A few tips: Range(Cells(Target.Row, 27), Cells(Target.Row, 27)).Value is not the right way, as both ranges point to the same cell. Ju...