Hi All,
I'm having a hard time trying to figure out how it is possible to use a for loop to grab and compare values on various sheets and put them on another sheet.
For example:
I want to compare two values on Sheet1 =A1-B1
However, I'd like to do this from Sheet4 in C1. So C1=Sheet1!A1-Sheet1!B1
But then I want to do the same thing again on Sheet2 from Sheet4 in C2, i.e. =Sheet2!A1-Sheet2!B1
And then again on Sheet3.
Hopefully that all makes sense. So my question is how can I accomplish going through several sheets like this in a for loop? I just can't quite wrap my head around the syntax. Thanks!
Bookmarks