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