Last seen: Jul 3, 2025
Yes, it's all there. Remember you asked about KeyList, that argument takes the list of keys used in the merge, you said there can be different number ...
See post 8 above, I already gave you the answer: TableName="Table1" Source= Excel.CurrentWorkbook(){[Name=TableName]}[Content] --> this returns ...
Please stop creating new topics on the same problem. The answer to this question was already posted here: All your other new topics you created are ...
You are chasing your own tail and I have no idea what you're trying to do. Which is the table you are trying to remove columns from? #"Grouped Rows...
I would like to have the same tab color sheets gethered in one file. Then what's wrong in the initial code that I sent you? That is EXACTLY what ...
Or, you try a stronger version, that also handles file permission errors, does not add hyperlinks at all (a double click on the cell you want will ope...
You have reached a limit in excel, but not the Integer limit as I initially thought, it's the maximum hyperlinks limit you have reached: 65530 hyperli...
Option Explicit Sub CopySheetsByColor() Dim Wks As Worksheet, NewWb as Workbook For Each Wks In ThisWorkbook.Worksheets If not Wks.Tab.Color=...
= Table.AddColumn(#"Grouped Rows", "List", each Table.Column([ColumnsToKeep],"ColumnName")) Where is the text in red coming from? The table from...
As mentioned in your previous topics, a table column is a list. You have to refer to a single column from a table to get a list of items in that co...
TableName="Table1" returns a text. Source= Excel.CurrentWorkbook(){[Name=TableName]}[Content] returns a table where the table name is provided by t...
= Table.SelectColumns(TableName, ColumnsToKeep) TableName is not a table, it's the NAME of a table. The function needs a table, not a name.
If you move the credit field into Filters section of the pivot, You can use the option Show Filter Pages, this will create a sheet for each credit amo...
Hi Lakhani, You can visualize data in a single place, using a pivot table, as in the example attached, better than lots of sheets. The solution ...
Hi Vee Dee, Try this code: Option Explicit Sub CopySheetsByColor() Dim SheetColors As Object, Wks As Worksheet, Arr() As Variant, Counter A...