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 ...
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.
Your request in the first post was "I need to make sure if for example, $15.00 is listed 4 times on sheet 1, then on sheet 2 $15.00 is listed four times."
That suggests creating a rule for column A on Sheet1.
Now you write "I need to verify that all the amounts from sheet 2 are on sheet 1."
That suggests creating a rule for Sheet2.
Which is it?
- I need to verify that all amounts from sheet 2 or listed on sheet 1. There are going to be times that the amounts will not be there, and that is okay. I had it as a TRUE or FALSE output, so the FALSE once I will review.