Working across sheets

Hello Shan,

Hope you enjoyed your Microsoft Excel Introduction course with Best STL.

Thank you for your question regarding how to use formulas across multiple sheets.

Let's say you have three worksheets in a workbook and there is data on all three sheets. You now decide that you would like to create a formula which calculates the Vat on sales on sheet 1. Sheet 2 contains all rate data such as Vat, exchange rates etc. So your formula to calculate the Vat on sales has to use the cell on sheet 2 which contains the vat rate.

To do this select the cell where you wish to calculate the Vat amount on sheet 1 and then press = click a cell which contains the sales value press the * key to multiply and select sheet 2 and click the cell which contains the vat rate and press enter. If you are going to copy the formula down to other cells make sure that you insert the $ signs into the cell reference taken from sheet 2 (vat rate).

So all you are really doing here is creating formulas as you would normally do on a single sheet but where necessary selecting cells from other sheets to be included in your formula.

Our Intermediate course covers this aspect in more detail and you would learn a lot more by attending such a course.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer