How to link two (multiple) workbooks and cells in Excel

http://www.TeachMsOffice.com
How to link two or more workbooks and cells in Excel. Basically just cell linking between workbooks explained.


Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website:

http://www.TeachMsOffice.com

Category:

Education

Tags:

• excel
• linking
• workbooks
• cells
• worksheets
• multiple
• two
• referencing

[camfarooqq]

Asak......Thank u soo much ,i hve been searching for this link up alott..but i've landed up here and its very smooth and understanding session i had with it.......thnx once again........& i raised a question during session & here am....how to update the data in link-example,whenever i insert any data in link-test.....plzzzz tell me ......and also i wanna download this whole set.how to do dat........waiting for the reply......tc god bless u

[ExcelisHell]

@camfarooqq at teachexcel. com there should be a link somewhere to download the spreadsheets.

[UnitedPebbles]

So I noticed Excel have database function as well? seem redundant? Access & then Excel?

[ExcelisHell]

@UnitedPebbles Essentially, yes. However, Excel offers many more 'visual' or user friendly options and is therefore easier for someone to learn to use.

[k8vnr]

Thanks, Great guide! Being so new to this i need a bit more help if poss, so stupid question time :)

How can you keep adding to the bottom of the list without having to redo this linking procedure?

Thanks

[ExcelisHell]

@k8vnr sent reply via PM on youtube

[MRichDude]

Been fun watching have to try this Thanks again :)

[MrShusha88]

good job :)

[substantialiffi]

Wowww.... Excellent.... really so helpfull... thanks for uplaoding this video... I really wanted to learn this linking methods of excell n I am so happy coz I have completely learn it only because of this video. Thanks alot... God Bless!

[samsungprin]

helped me a lot! thanks!

[bluebirie]

good job