It may have been an incorrect assumption of mine, but I figured he wanted to make a lot of these text displays for hundreds of calculations (thus looking to automate it via formula). But perhaps I over thought it ha ha
Haha yes, I 'm looking for a way to display something automatically. I want subsequent boxes to _ automatically _ formulas from OTHER cells (if that’s possible)
Hmm. In that case, let’s use VBA and call this function “getFormula”. Writing on iPad, so might have syntax errors.
function getFormula(y as int, x as int)
getFormula = cells(x, y).formula
end function
invoke this function as such: =getFormula(row(B3), column(B3))
You might want to control for ActiveSheet also. So, somehow feed in the worksheet name for the cell B3 that you are referencing. As mentioned, I’m writing this without a computer, so might have incorrect names here and there. The general approach will work though.
Anything in “” would be text. So “/” inserts the line inbetween the cell references. & joins cell references. For example, I make a lot of autopopulating data visualizations. So if A1 is Coke and A2 is Income (but both of these change depending on the data pulled), I could make Cell A3 = A1 & " 's " & A2 & " Trends over time period". That would then show Coke’s Income Trends over Time Period. I then reference Cell A3 in the graph’s title.
I copy/pasted those formulas I wrote for you into a worksheet and it worked correctly (I’m using 2010 but this should work in 2007). If you don’t want to go the VBA route, reply with the formula that gave you an error. I’ll let you know what is wrong with it