Forum Discussion
Excel - VBA Help - Two Sheets matching amounts
I have two sheets that I need to compare from each other. On sheet 1, in column CR, I have a column of amounts, that I need to verify if all are listed, compare to Sheet 2, columns, S-AC. there are ...
Perhaps change
ActiveCell.FormulaR1C1 = "=COUNTIF(Sheet3!S:AC, Sheet4!CR)>0"
to
ActiveCell.Formula = "=COUNTIF(Sheet3!S:AC,CR1)=COUNTIF(CR:CR,CR1)"
- That did not work. It only worked for some of the cells, but did not count on all of them.
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
HansVogelaarI have attached a sample workbook. I need to verify that all the amounts from sheet 2 are on sheet 1.
