Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COMPARE 2 WORKBOOKS
Dear All
I need a VB macro for the following purpose. The scenario:- I have a workbook(book1.xls) with 10 sheets(Sheet1, Sheet2, Sheet3 etc). All sheets contain data(text) in column A. I have anothe workbook(book2.xls) with 1 sheet(Sheet1). This book also contain data(text) in column A. What I want to achieve:- 1. If the data in cell A1 from book2.xls is found anywhere i book1.xls, then cut cell A1 from book2.xls and paste in next to th found cell in book1.xls. 2. Repeat process for cell A2, A3, etc until there are no more data i book2.xls or there are no more matches. Example:- 1. The data in cell A6530 of book2.xls is also found in Sheet9 cel A8665 of book1.xls. 2. Cell A6530 of book2.xls is cut & pasted in Sheet9 cell B8665 o book1.xls Additional info: 1. The number of rows in book2.xls are not fixed(may change) 2. The number of rows in all 10 sheets in book1.xls are not fixed(ma change). 3. I need the script to MATCH CASE when searching 4. I need the script to search partial matches 5. Book1.xls is really BIG so the code must not run out of memor halfway Thanks a lot for contributing your knowledge. ROBERT RA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare workbooks | Excel Discussion (Misc queries) | |||
Compare workbooks | Excel Discussion (Misc queries) | |||
compare different workbooks | Excel Worksheet Functions | |||
Compare Excel Workbooks | Excel Discussion (Misc queries) | |||
Compare and Merge Workbooks | Excel Worksheet Functions |