An open-source TypeScript project for Microsoft Excel 365 that extracts data from sheets with similar naming patterns and outputs the results to a new sheet.
This project is licensed under the MIT License.
R4WD4WG, 05/01/2023
- Look for sheets with similar naming patterns
- Perform lookups for corresponding values
- Output results to a new sheet
- Save the Office Script file to:
Documents/Office Scripts(create the folder if it doesn't exist). - Launch Microsoft Excel 365.
- Open the "Automate" ribbon at the top.
- Click "New Script" on the left side of the ribbon.
- The script should appear. If not, copy & paste the content into a new script within Excel.
Customize cell references, sheet names, etc., to fit your needs. The script can scale to any size depending on computing power.