Combine cells and use as a worksheet name within the same formula
Posted on 2015-01-30
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.
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.