omniscience
11-19-2013, 04:05 AM
Hey, everyone I am having difficulty with something that I'm sure is simple enough to put together. Politely asking for some assistance or direction.
I am using Excel 2010.
I have 2 sheets set up as follows:
-Vendors in Column A.
-Months of the Year in Row 2. (this will be ongoing, likely spanning many years)
-Currency Values are in the table. (some vendor salaries are paid multiple months)
What I would like to do:
The vendor lists from both sheets are of different length. Sheet 1 has expenses. Sheet 2 has the estimated budget.
I assume the macro would have to do this all in one step:
Part 1:
I need to compare cell values based on:
Compare the two vendors columns (Sheet 2 Vendors list is smaller). Find matches. Scan the row and find the cell that has the same column month. Compare the cells.
Part 2:
I would need some conditional formatting based on the comparisons.
Something like this:
-If the values are the same. = Green.
-If one is greater than the other = Red.
-If one is less than the other = Blue.
I would greatly appreciate any help anyone could provide. I have attached a sheet with an example. I tried to fill it out the best I could. Please see Sheet1 (the lookup sheet) Sheet2 = the sheet that needs the markup and highlighting.
I am using Excel 2010.
I have 2 sheets set up as follows:
-Vendors in Column A.
-Months of the Year in Row 2. (this will be ongoing, likely spanning many years)
-Currency Values are in the table. (some vendor salaries are paid multiple months)
What I would like to do:
The vendor lists from both sheets are of different length. Sheet 1 has expenses. Sheet 2 has the estimated budget.
I assume the macro would have to do this all in one step:
Part 1:
I need to compare cell values based on:
Compare the two vendors columns (Sheet 2 Vendors list is smaller). Find matches. Scan the row and find the cell that has the same column month. Compare the cells.
Part 2:
I would need some conditional formatting based on the comparisons.
Something like this:
-If the values are the same. = Green.
-If one is greater than the other = Red.
-If one is less than the other = Blue.
I would greatly appreciate any help anyone could provide. I have attached a sheet with an example. I tried to fill it out the best I could. Please see Sheet1 (the lookup sheet) Sheet2 = the sheet that needs the markup and highlighting.