Comparison or two sheets

C

Chuck

I need to compare a column in one spreadsheet to another column in a second
spreadsheet. They will be numbers. I need the difference to be placed in a
third spreadsheet in the corresponding rows. Would it be better to use
macros in the cells or to create a VBA program? Since this will be done
many times with different sheets, I guess creating template (for the third
sheet) would be best. Any good approaches?
 
G

Guest

Hi Chuck,
=IF(Sheet2!A1=Sheet1!A1,"",+Sheet1!A1-Sheet2!A1)
Above compares A1 to A1 sheets Sheet1 and Sheet2, puts a ""(Blank) if they
are equal and if not it subtracts one value from the other.
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

Excel comparison of two sheets 1
comparing two columns in vba 2
passing a non numeric cell for numeric comparison 2
Comparing two workbooks - Excel 2010 - not using Add-ins 2
Importing and exporting sheets from spreadsheets 1
compare pairs of columns 3
Comparing two columns 7
Compare two Sheets 1

Top