How I can compare numbers in one book to another book

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How I can make macro to compare numbers in one book with 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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run code from another workbook 7
... another request for a book recommendation. 1
Word Create a Phone Book using MailMerge in word 2007 0
Can I refer to a sheet in another book by its codename? 4
how to write a macro to club data in multiple excel workbooks into asignle one??? 1
HELPPPPP Please - Comparing Data 6
Vacinations ??? 4
Excel Protection 2

Back
Top