HI I have been using a program called Excel pipe from Data Mystic on a PC - It basically lets you search and replace on a massive scale in Excel.
You can have hundreds of original and replace values in the first spreadsheet and it will use this to go through hundreds of individual seperate spreadsheets in a folder and replace these values throughout them all. Very handy for many price updates over differnet SKU's in many different spreadsheets.
Does anyone know of a Mac app that can do this?
Thankyou in advance
You can have hundreds of original and replace values in the first spreadsheet and it will use this to go through hundreds of individual seperate spreadsheets in a folder and replace these values throughout them all. Very handy for many price updates over differnet SKU's in many different spreadsheets.
Does anyone know of a Mac app that can do this?
Thankyou in advance