How to reference cells without the sheet name
Requirement:
The user has ~130 data sheets for multiple projects with an index at the beginning. The user wants to reference certain cells from the individual data sheets in the workbook to auto-fill in the index. All the data sheets are labeled 'INSERT TAG NO', but the user wants to formulate the index cells to use Sheet2, Sheet3, etc.
Solution:
Code:
=INDIRECT("'INSERT TAG NO (" & 2 & ")'!S2")
Obtained from the OzGrid Help Forum.
Solution provided by JonathanVH.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to turn surname and first name around |
| How to merge multiple excel files into one file in separate sheets with source file name |
| How to test if named range exists |
| How to use the namebox shortcut key |
| How to paste from multiple Excel workbooks into one workbook (Across the page & file names) |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
