Excel Macro
$30-200 USD
货到付款
Good Day,
I am looking for a Macro that will do the following.
1. I will have a .xlsx spreadsheet in a FOLDER: Ex: C\foo
2. I will open [url removed, login to view]
3. Find the value in COLUMN O Ex: 101245 - Corn Farmers
4. Open a new 101245 - Corn [url removed, login to view] Spreadsheet
5. Copy ALL ROWS with the SAME value in COLUMN O to Newly [url removed, login to view]
6. Save Newly [url removed, login to view] to Value In COLUMN O Ex: 101245 Corn [url removed, login to view]
7. Close Newly [url removed, login to view]
8. Repeat until ALL values in COLUMN 0 have been processed.
This will leave a folder with:
1 - [url removed, login to view]
2 - Newly [url removed, login to view] files with unique names based on COLUMN O
项目ID: #3432838