Is there a 3D formula that generates text?

Microsoft Office excel 2007 - upgrade
March 12, 2011 at 17:04:13
Specs: Windows XP
Cell "B2" is empty on every sheet except for B2 of sheet "5". Using a 3-D formula, is it possible to generate on my summary sheet the text that is in sheet 5 cell B2. I'm thinking that a 3-D formula is my only hope at this point because the relevant text is going to move from B2 of one sheet to B2 of another sheet several times throughout the year. If anyone could help, I'd sure be grateful.

See More: Is there a 3D formula that generates text?

Report •

March 15, 2011 at 17:42:46
if you want one cell to display the same content as another cell, all you need to do is enter the following in the desired cell of your summary sheet:
1)in the desired cell of your summary sheet start by hitting the "=" button.
2)WITHOUT TYPING ANYTHING ELSE, carefully use your mouse to navigate to the desire sheet and then select the desired cell.
3)now just hit ENTER.

you should see a formula like this:

whatever is calculated/displayed in cell B2 of that particular sheet, will show up in the cell that you just entered the = into.
If this isnt what you're looking for, let me know.

Report •
Related Solutions

Ask Question