Forum Discussion
Dfuhrman8
May 02, 2022Copper Contributor
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 ...
Dfuhrman8
May 02, 2022Copper Contributor
That did not work. It only worked for some of the cells, but did not count on all of them.
HansVogelaar
May 02, 2022MVP
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.
- Dfuhrman8May 02, 2022Copper Contributor
HansVogelaarI have attached a sample workbook. I need to verify that all the amounts from sheet 2 are on sheet 1.
- HansVogelaarMay 02, 2022MVP
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?
- Dfuhrman8May 02, 2022Copper ContributorI 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.