compare books

B

bill

i have a macro that creates a book then creates an updated book before
deleting prior book. how would i write a macro to compare col C and col F
with col C and col F of new book. if there is a change of 100 or more in
one of cells then send an alert and copy sheet 1 of the workbooks to sheet
1&2 in worlbook temp.

thanks
 

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

Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
Resize a row but copy but skip columns I don't want to copy 6
Six columns randon no.'s no dupes 6
Compare two different workbook sheet to show the difference in text 0
Macro to look up values in 2 different columns 3
Macro for comparing columns and highlighting matching/differences 13
VBA If Statement 2
comment copy 3

Top