Forum Discussion
Excel - VBA Help - Two Sheets matching amounts
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.
I can't say that's entirely clear to me, but if I understand you correctly, it's the opposite of what you originally asked.
I created a conditional formatting rule for Sheet2. See the attached version.
I need a formula that will take a list of values from one sheet, and compare them to a different sheet. Sheet 1 has column A with amounts and then column B with type of charge. Sheet 2 has the type of charges going across in a row - travel, training, meals, etc, and then amounts going down in each column. I need a formula to verify that sheet 1 has all of the information from sheet 2.
