This trick comes in handy when you’re trying to do some calculations from data that are located in different excel worksheets.
Let’s look at an example:
1. You have 5 and 6 laid out in cell A1 and B1 on sheet 1
The real trick is to use the worksheet name in your excel formula. Study step 3 and you’ll get what I meant. In this case, the worksheet names were sheet1 and sheet2. If you have different worksheet names, change accordingly in your formula.
That’s it. Have fun!