You might be using macros for work or something personal but regardless they can be immensely helpful. In this post I will show you how to enable them so that you can use them.
Firstly open up Excel and navigate to and click on ‘File‘.
Down the bottom of the list you want to click on ‘Options‘.
Next you need to click ‘Trust Center‘ and then click on ‘Trust Center Settings‘.
Now you need to click ‘Macro Settings‘ on the left and this is where you can choose which macro settings you would like, be careful here, as it says macros can contain potentially dangerous code to run so enable all macros at your own risk.
I personally would recommend against enabling all macros but if you’re sure the macro is safe e.g. you’ve made it yourself then enable it.
Go to File > Options > Trust Center > Trust Center Settings > Choose your macro settings.
Follow this guide at your own risk, we take no responsibility as macros can be used negatively by hackers to run dangerous code.
In todays post I will show you how to use a cell from another sheet in your spreadsheet, in your formula.
In this example, I want to get the answer of cell A1 on page 1 added to the cell A1 on page 2 and display the answer in D10 on page 1, to do this I simply want to click the formula for D10 and type in ‘=A1+Sheet2!A1‘ as shown (A1 doesn’t need the ‘sheet‘ part as it’s on the same sheet as D10 but it can still be used).
As you can see above both of the A1 cells have 100 in them therefore D10 has returned the correct answer of ‘200‘, it’s as easy as that!
You can just follow the syntax of ‘Sheet1!‘ 1 being the required sheet number followed by the cell number e.g. Sheet2!B6, Sheet4!Y8 etc. You can string them together too and have as many as you want. Need to add 8 cells from 5 different sheets? Go for it.
Here is the result of a 4 page one, note the formula at the top.
And that’s all there is to it, you can also instead of typing the formula simply type ‘=‘ and then click the sheet you need followed by clicking the cell and it will put it in for you automatically.
To sum up cells on different sheets simply follow the formula ‘Sheet1!A1+Sheet2!A1‘ and change the sheet, cell numbers and formula as necessary.