Editing excel is fast and simple using DocHub. Skip installing software to your PC and make alterations with our drag and drop document editor in just a few easy steps. DocHub is more than just a PDF editor. Users praise it for its efficiency and powerful capabilities that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and send records for completion to other people. All of this, combined with a competitive price, makes DocHub the perfect choice to work in cross in excel files with ease.
Make your next tasks even easier by turning your documents into reusable web templates. Don't worry about the protection of your data, as we securely keep them in the DocHub cloud.
- [Instructor] For many users, itamp;#39;s 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. Letamp;#39;s cover some of these features. In this workbook, linkage formulas weamp;#39;ve got data for four different States. Now this data happens to be alike in terms of layout. Thatamp;#39;s not a requirement for some of the things weamp;#39;re gonna be doing, but for other things, it will be. Iamp;#39;ve got a sheet called Totals here. And what Iamp;#39;d like to do is get the total for California here. Now, jumping over to California, weamp;#39;ll 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 weamp;#39;re imagining this model might be growing. Maybe weamp;#39;re a major retailer, but we only ha