Search : in
By :

EXCEL Macro - Find and replace function -Help

Last answer on Oct 6, 2008 8:14:56 am BST FER River, on Sep 15, 2008 6:49:33 pm BST 
 Report this message to moderators

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
Configuration: Windows XP
Internet Explorer 6.0
Best answers for « EXCEL Macro   Find and replace function  Help » in :
 Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows


Issue
Solution
Note


Issue

I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
			
 Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range


Issue
Solution
Note


Issue

I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
			
 EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function





You have a table consisting of rows and columns. 

Want to know the value of the cell at the intersection of a particular row / column in your table

Example: 

Your table: 
- starts C3 to F3 ......
			
 Download Multiple File Search and Replace Show
			
 Download Excel Macro Processor Show
			
 Download Advanced Find&Replace for Excel ShowDescription

This application is designed by Add-in Express LTD. Advanced Find & Replace is an add-on for Microsoft Excel. It allows you to run multiple searches for values, formulas and comments. The search results are displayed in a floating...
			
Ask your question Reply
1 
 Easy dude, on Oct  6, 2008  8:14:56 am BST
  • +49
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?
   
Reply to Easy dude

	

	
Ask your question Reply
They need your help