Search results 59

Sorted from new to old.

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

1 2 3 4