Learn Excel Episode 681: Indirect

Posted in Companies, Podcasts on July 13, 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.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, INDIRECT, summary worksheet