Hi,
I need to find/make a program that will allow me to delete specific cells from hundreds of excel files. I.e. delete cells (make them blank).
m10, n10, m50, n50, l250 and u46 from 800 excel files.
I've searched for search and replace programs and there is a few ones out there that don't really work. I.e. I can search for "hello world" and have it replaced with "something", but only in the entire spread sheet, or one cell at a time. I want to do all the cells I want to delete in all the files at one go.
Your help would be greatly appreciated!
Mike
I need to find/make a program that will allow me to delete specific cells from hundreds of excel files. I.e. delete cells (make them blank).
m10, n10, m50, n50, l250 and u46 from 800 excel files.
I've searched for search and replace programs and there is a few ones out there that don't really work. I.e. I can search for "hello world" and have it replaced with "something", but only in the entire spread sheet, or one cell at a time. I want to do all the cells I want to delete in all the files at one go.
Your help would be greatly appreciated!
Mike
Microsoft Excel question.