Last seen: May 22, 2025
You could also put those values into a column of cells and use that as criteria in an advanced filter.
It's expecting a list of items to remove so use {"Col3"} instead of just "Col3": let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content...
The prior step works fine for me (after creating an appropriate source file for the state list). For a direct in-place replacement, you could ...
Shouldn't the last step read something like: = Table.AddColumn(#"Added Custom", "Address2", each Text.Replace([Address], [States], " ")) ...
There are probably simpler solutions, but you could get a list of the column names, remove the last one (the new column you added) and then combine th...
Make sure the Zip field loads as text, then you can use something like: = Table.AddColumn(#"Changed Type", "CleanZip", each if Text.Length([Address...
I'd suspect the problem lies elsewhere (in the code you didn't post) since I can't see how you'd get a file count for a non-existent folder.
They are visible, just not active - you still have the front sheet selected which is entirely grey. Also, the sheet tabs have been hidden so there is ...
What is the formula?
The Activate code in the form protects the workbook. That means that you can't then change the visibility of any sheet unless you unprotect the workbo...
You've used a colon instead of a semicolon in the name definition - it should read: =$AP$6:index($6:$6;counta($6:$6)+1))
ADDRESS returns text, not a range reference, so you'd need to use INDIRECT: =AP6:INDIRECT(address(6;counta(AP6:BJ6))) or perhaps just:...
It looks like you've already got the basic code - just amend for example FileToOpen in your first routine to use a specific path and file name rather ...
Try adding: ChDrive "H:" ChDir "H:PROJECT-OPSNSW WarehouseNSWTA Inventory Listing" before the line to select the file.
You could use something like COUNTIF instead of Find: Sub Draw() Dim i As Integer, Number As Integer Dim DataRange As Range Set DataRange =...