Create Live Cell Reference

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I need to create a cell reference based on the current
value in another cell. For example, if the value in cell
B1 is "C", in another cell I need to create a reference
to "C4". If, however, B1 = "D", I need the reference to
be "D4". Any ideas?
 
Hi
see your reply in Excel.worksheet.functions

P.S.: please don't multipost
 
Thanks Frank.
-----Original Message-----
Hi
see your reply in Excel.worksheet.functions

P.S.: please don't multipost


--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Condition 4
Add to an Existing formula in a Cell using VBA 1
Conditional formatting with merged cells 3
How do I reference cells in CF formula within loop 2
Create Live Reference 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Cell Referencing in VBA 2

Back
Top