Look to Cell References to a Worksheet

Sponsor

Excel Formulas Look to Cell References to a Worksheet [Q]

I have a microsoft excel formula in Sheet3 in cell A1 that is something like this:

=Sheet1!A1

This excel formula of course is looking to Sheet1 for the contents in cell A1 and placing it in cell A1 of Sheet3. In Sheet3 I have in cell A2 the following text Sheet1. What I would like my excel formula to do is to look in cell A2 of Sheet3 for what worksheet to look for. For example, instead of =Sheet1!A1 it would be something like =A2!A1
I know this doesn’t work, but how do I reference the contents of cell A2 to
give me the excel worksheet number that I want to reference.

Excel Formulas Look to Cell References to a Worksheet [A]

This excel formula should solve your problem:

=INDIRECT(A2&”!A1″)

or to be safer:

=INDIRECT(”‘”&A2&”‘!A1″)

here there are single quote as well a double quotes

Further details Look in Microsoft Excel Help Menu for the INDIRECT( ) function

Rate This Tips:

Incoming excel search terms

remove references from excel,self reference excel,dynamic sheet reference excel,excel dynamic sheet reference,excel formula worksheet reference,excel indirect sheet reference,excel look for cell,excel self reference cell,excel worksheet formulas,excel worksheet reference,how to give cell reference to macros in excell,self reference cell excel,vba excel cell reference a1,worksheet reference excel,1,automatically updating self referencing cells excel,calculate cell reference excel,calculate worksheet reference excel,cell reference excel date,cell reference in double quotes in excel,cell reference in excel vb,changing worsheet reference excel formula macro,combining cell contents to give references in excel,dynamic reference to excel worksheets in formula,dynamic sheet reference in excel formula macro,dynamic sheet reference in formula,dynamic worksheet reference excel,excel - adding a worksheet reference in a cell,excel cell reference self,excel cell self reference,excel dynamic worksheet reference,excel formula cells references,excel formula give me cell reference,excel formula sheet reference,excel formula to look at a sheet number from a cell,excel formula worksheet,excel formulas look to cell references to a worksheet,excel function look for text,excel indirect different worksheet,excel indirect worksheet,excel macro cell reference self,excel problem with cell reference in another sheet,excel reference a sheet in a formula,excel replace sheet number with cell value in formula,excel self reference,excel self-referencing,excel selfreference,excel sheet reference by formula,excel vba dynamic reference to sheet name,excel workbook reference problems

Related Excel Tips

• Using Percentile with Specific Cell in Worksheet (0)
• Conditional Formula in Different Worksheets (0)
• Calculate Age from Two Date Cells (2)
• Writing a Formula Which Dynamically Generates Results (0)
• Intersection of Two Tabs in Excel Worksheet (0)
• IF Statement Calculating Average Has Numeric and Text (0)
• Automatically Insert Number of Days in Specific Month (0)

Comments

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 14,329 views
  • Date Calculation Start Date Minus Year, Month and Days - 14,032 views
  • Macro VBA to Remove Characters in String of Text - 13,222 views
  • Combine Multiple Workbooks Overcome 255 Char Limit - 11,974 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 11,199 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 11,032 views
  • Insert Introduce Time Delay in Macro Vba - 9,564 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • Change Worksheet Tab Colors (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Quick Way Determine The First and Last Business Day of the Month (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Date Calculation Start Date Minus Year, Month and Days (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous