Never Miss a Beat: Get a snapshot of the issues affecting the IT industry straight to your inbox.
July 9, 2011
1 Min Read
MS Excel lets you reference data from different worksheets. To do this, use the worksheet title followed by an exclamation point. This way you can perform any calculation that you would with data or cell references, but within one worksheet.
For instance, in the image below, I took data from Cell B2 of my worksheet titled Software and placed it in cell C2 of the worksheet titled Hardware. I did this by typing =Software!B2 into cell C2 of the Hardware worksheet.
You May Also Like
Edge Computing's value to IT
5 key areas for improved automation in InfoSec compliance
*State of Accounting and Legal Services
KVM SwitchÂ High Performance Applications with Dominion KX III
Solution Brief: Fortinet FortiFlex Delivers Usage-Based Security Licensing That Moves at the Speed of Digital Accelerationâ€‹