| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace Data from one into another
Hello
I have two excel file id.xls and amount.xls ID.xls format ID Amount 12345 100 54321 200 11111 250 33333 500 Amount.xls format Column A Amount Total 12345 Total 11111 Total 33333 I want the macro to find the ID from id.xls and replace the amount from ID into amount.xls, and if it couldn't find the id in amount.xls it has to skip and find the next id till the eof in id.xls Thanks for any suggestion. --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace with formated data | Excel Worksheet Functions | |||
| find and replace data | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| How to find/replace data in column | Excel Discussion (Misc queries) | |||
| How to find/replace data in column | New Users to Excel | |||
Threaded Mode
