<div>
<div class="content wysiwyg-content">
I am trying to combine 2 cells together to make the name of another worksheet within the same workbook. &nbsp;All so I can use references to another worksheet in a formula.<br />
<br />
Setup:<br />
Worksheet1 = Dashboard<br />
Worksheet2 = House1<br />
Dashboard.CellA7 = House<br />
Dashboard.CellB7 = 1<br />
Dashboard.CellC7 = =A7&amp;B7&amp;!B6 (want to translate to &quot;=House1B6&quot; or &quot;Bob&quot;)<br />
House1.CellB6 = Bob<br />
<br />
The spreadsheet has confidential info in it so I cannot send the actual workbook. &nbsp;Since I cannot get this to work, I am not sure if making a &quot;dummy&quot; workbook would be very helpful.
</div>
</div>


I am trying to combine 2 cells together to make the name of another worksheet within the same workbook.  All so I can use references to another worksheet in a formula.

Setup:
Worksheet1 = Dashboard
Worksheet2 = House1
Dashboard.CellA7 = House
Dashboard.CellB7 = 1
Dashboard.CellC7 = =A7&B7&!B6 (want to translate to "=House1B6" or "Bob")
House1.CellB6 = Bob

The spreadsheet has confidential info in it so I cannot send the actual workbook.  Since I cannot get this to work, I am not sure if making a "dummy" workbook would be very helpful.

Combine cells and use as a worksheet name within the same formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.