Previous Topic Next Topic

EXCEL Macro - Find and replace function -Help

Closed
FER River - Sep 15, 2008 at 01:49 PM
 Easy dude - Oct 6, 2008 at 03:14 AM 
Hello, I work for a customer care ... I need to set a macro to delete customer information in the same file --  around 30,000 contact.



I was thinking to use the find and replace function - but it does ONLY work for the original contact ---



I can say find the text on C7 (customer address) then => check for the text in the file and replace the text to "UNK"



how can I define this code in visual basic.??????



Please Help            
                

    

        



            

                
                
            

            

    

    
            

            

    

    
    

        Related:         
    




    

        
        

                
1 response

        

        
    


            

        
        
        

                        Answer 1 / 1
        


        
                            
                        
                    

                

        

                    

        
    
    

            

    

        

            Easy dude                    

                    Oct  6, 2008 at 03:14 AM
                        

    


    

                        

                            

                    Let me get it:you have 2 files with the same data structure and you have to replace the data in one of them by lookuping it in the other?