Having it look at the worksheet for the replace will help.When I need to add new stores it is a pain using the find and replace. The WSdatabase will be much better. I have one similar to replace the prices. I attached another module. It basically does the same thing just does not need the negative one. So I was just able to include them all into on module so I don’t need to import more than one module. I tried to do the same but it keepsfailing at the private function. So, I will look into what you mentioned but just to show you what I am trying to do.
Reply With Quote