Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Go behind the scenes with some of the biggest digital celebrities to see what life is like when the blogging and tweeting stops.
The story of punk rock singer Laura Jane Grace of Against Me! who came out as a woman in 2012, and other members of the trans community whose experiences are woefully underrepresented and misunderstood in the media.
Documentary shorts conceived of and directed by famous actors. Jeff Garlin, Katie Holmes, Alia Shawkat, Judy Greer, and James Purefoy
Park Bench is a new kind of "talking show" straight from the mind of born and bred New Yorker and host, Steve Buscemi.
Digital influencer Justine Ezarik (iJustine) is back. After covering the world of wearable tech last season, iJustine is expanding her coverage this year by profiling the hottest tech trends across the country.
A 12 episode documentary series following 5 startup companies competing in the 2013 San Francisco TechCrunch Disrupt Startup Battlefield as they fine tune their products and eventually present in front of a panel of judges in hopes of winning $50,000 in funding.
Enter the graceful but competitive world of ballet through the eyes of executive producer, Sarah Jessica Parker. This behind-the-scenes docudrama reveals what it takes to perform on the ultimate stage, the New York City Ballet. Catch NYCB on stage at Lincoln Center.
Nicole Richie brings her unfiltered sense of humor and unique perspective to life in a new series based on her irreverent twitter feed. The show follows the outspoken celebrity as she shares her perspective on style, parenting, relationships and her journey to adulthood.
Explore what it means to be human as we rush head first into the future through the eyes, creativity, and mind of Tiffany Shlain, acclaimed filmmaker and speaker, founder of The Webby Awards, mother, constant pusher of boundaries and one of Newsweek’s “women shaping the 21st Century.”
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity.
Hank Azaria’s touching, humorous, and often enlightening journey from a man who is not even sure he wants to have kids, to a father going through the joys, trials and tribulations of being a dad.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
This video accompanies the How to Link Cells in Different Excel Spreadsheets article on www.VitaminCM.com. You will learn ...
how to link data in one Excel Spreadsheet to data in cells of another worksheet or workbook using linking formulas.
Tags:How to Link Cells in Different Excel Spreadsheets,Excel Spreadsheet,vitamincm,excel tutorial,how to link spreadsheets,linking cells,linking excel spreadsheets,microsoft excel,video tutorial
Grab video code:
How to Link Cells in Different Excel Spreadsheets
Hi this is Christopher Masiello for VitaminCM.com and today I'm going to show you how to link information between Excel worksheets and Excel workbooks. So I have a couple of Excel spread sheets open here by switch to the folder I had three spreadsheets. One of them is East Coast Sales, the other is West Coast Sales and then the other is Consolidated Sales. And I'm going to show you how to link information between all this different sheets. So I want to go the one called East Coast Sales right now and I had three worksheets in here, I have a worksheet that attracts products, I have a worksheet that tracks services and then I have a worksheet that tracks totals so the total sales from both. What I want to be able to do is get the data combined from my products tab and my services tab up into this totals tab. So I'm going go into the products row for Sunday. And I’ll go up here and hit equals and then I’ll click to the products tab and I’ll get the total sales from Sunday, I’ll hit the enter key and it will populate in.
I also have it total linked down. So I want to get the services totals for Sunday also, so I’ll hit equals. And then I’ll go to the services tab and click the totals for Sunday, hit enter and there it is it totals up for the day. Now I want to do that for all of the rest of the days so I will just go to the little square in the corner of that sale and drag it out for the rest of the week and it will populate, I’ll do the same with services. I’ll click on the little black square in the bottom, drag it out for the rest of the week and it will populate I need to resize my cell, so you can see all the number.
So you see I have linked data between tabs inside the same workbook so from worksheets to workbooks. What I want to do now is switch over to my West Coast Sales spreadsheet and you could see if you go to the top tab the total tab that I’ve already done this for the products and services. Now, if I went back you could see this numbers $36,959.00 if want it back to the services tab and change the number and then go back here you’ll see it went from the $36,000.00 to $41,000.00. So it's all dynamically linked updates anywhere in the underlying cells will roll up into the link cells. So that’s a way that you can link data inside the same file, from one worksheet to another inside the same workbook. But if I switch windows again to this consolidated sales workbook, what I want to do now is combine data out of those other two workbooks into this one and it works pretty similar so you have to have all the files open that you want to link.
So I have the East Coast and the West Coast open. So I’ll hit the equal button again and then I’ll switch over to the East Coast Sales workbook grab my totals and hit enter and it pulls it in. I want to do the same for the West Coast sales, so I’ll hit equal switch to West Coast Sales grab the totals and hit enter. And it pulls up and you could see the totals up to $75,727.00, so if I go back to either of these workbooks and change any of the underlying data. So I’ll add $5,000.00 to this and I’ll switch back to the consolidated and went from $75,000.00 to $80,000.00. So it’s all linked up. So I’ve linked data from one worksheet to another worksheet in the same workbook and then I’ve pulled that summarized data out of one workbook into a cell and another workbook and I'm calculating it against data pulled out of -- yet a third workbook to add against each other. And if I copy this cells out it would populate the rest and the formulas would give me totals for the whole week. So that’s a nice way to use the linking feature in Microsoft Excel to pull data from certain places in the spreadsheets to other places and even to other part.