Episode # 681 - Indirect

Using INDIRECT to build a Summary worksheet that can be copied to new workbooks.

Sponsored by

Check out this book for more tips
similar to this lesson!

Monday, January 28, 2008

Kambiz sends in a question. He has a Summary worksheet that points to Jan, Feb, Mar worksheets in his workbook. When he copies the worksheet to a new workbook, the formulas keep pointing to the Jan worksheet on the original workbook. In episode 681, we take a look at using the INDIRECT function to solve this problem. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 4 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: INDIRECT, summary worksheet

Episode # 681 - Indirect

Using INDIRECT to build a Summary worksheet that can be copied to new workbooks.

More Excel Video Lessons