Posts Tagged ‘linking’

Linking Cells in Separate Worksheets in Excel

Tuesday, June 16th, 2009

http://www.ExcelisHell.com
How to link cells between separate worksheets in the same file (workbook) within excel. This method also allows you to add formulas and functions in one cell and have those formulas affect data on a separate worksheet.

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

www.ExcelisHell.com

Duration : 0:4:10

(more…)

VLOOKUP Between Separate Workbooks and Worksheets in Excel

Friday, June 5th, 2009

http://www.TeachExcel.com
This will teach and show you how to use the vlookup function between separate worksheets and workbooks in excel.

You will learn how to use the vlookup to search through lists in closed workbooks and in separate excel files.

To follow along with the excel spreadsheet seen here and to find more excel stuff including free macros, keyboard shortcuts, and a forum, go to:

http://www.TeachExcel.com

Duration : 0:6:23

(more…)