Have you ever had trouble with editing your CWK document while on the go? Well, DocHub has a great solution for that! Access this cloud editor from any internet-connected device. It allows users to Adapt formula in CWK files rapidly and anytime needed.
DocHub will surprise you with what it provides you with. It has powerful capabilities to make whatever updates you want to your forms. And its interface is so easy-to-use that the entire process from beginning to end will take you only a few clicks.
Once you complete modifying and sharing, you can save your updated CWK file on your device or to the cloud as it is or with an Audit Trail that contains all changes applied. Also, you can save your paperwork in its initial version or convert it into a multi-use template - accomplish any document management task from anywhere with DocHub. Sign up today!
- [Instructor] For many users, its not uncommon to write formulas in some worksheets that get data from other worksheets within the same workbook. Less common, but also needed at times are formulas in one workbook that need to get data from worksheets located in another workbook. Lets cover some of these features. In this workbook, linkage formulas weve got data for four different States. Now this data happens to be alike in terms of layout. Thats not a requirement for some of the things were gonna be doing, but for other things, it will be. Ive got a sheet called Totals here. And what Id like to do is get the total for California here. Now, jumping over to California, well see the total here is in cell G8, and the totals for the other three States are the same. Part of the reason we might be doing this too, is were imagining this model might be growing. Maybe were a major retailer, but we only have stores in these four States right now. Were gonna be expanding, and eventual