| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How I can compare numbers in one book to another book
How I can make macro to compare numbers in one book with another book ?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How I can compare numbers in one book to another book
set sh1 = Workbooks(1).Worksheets(1)
set sh2 = Workbooks(2).Worksheets(1) sh1.copy sh2.cells.copy Activesheet.Cells.PasteSpecial paste:=Values, operation:=xlSubtract You could repeat for each matching sheet or reverse which sheet is subtracted to get the correct "sense" of the difference (positive or negative changes). -- Regards, Tom Ogilvy "timppa" wrote in message ... How I can make macro to compare numbers in one book with another book ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving worksheets to another book - 2nd book will not appear | Excel Discussion (Misc queries) | |||
| copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
| Missing Cheque numbers in a bank book | Excel Discussion (Misc queries) | |||
| to disconnect a destination book from a source book | Excel Discussion (Misc queries) | |||
| bank book or pass book | Excel Worksheet Functions | |||
Linear Mode
