Office 360 Excel formula with output to separate cell. No code

0
votes

Sorry if this is a old question, I have a requirement to have a value pushed from a cell on one sheet to another cell on anaother sheet, without setting the destination cell.

So: 'Sheet1!A1' has formula, 'Sheet2!A2' is where I would like the output to end up without setting the cell with ='Sheet!A1' or using VBA, otherwise we would not be here right now.

It seems like a simple ask the beginning but I'm stumped

1
excelformula
Not clear what you wanting to do? – Harun24HR
Sorry, I want to have cell A1 do 1+1 for example and another cell on a seperate sheet have the answer. The cell with the answer needs to be blank and i,m trying to not use code. So I want cell A1 to contain the formula that puts the answer in the other cell. – Chris
A formula can only return a value to the cell in which it is located. It cannot "push" a value to some other cell. – Ron Rosenfeld
AFAIK, your conditions of no code and no formula in Sheet2!A2 means that this requirement would be impossible to achieve in an automated way within Excel. As Ron said, Excel doesn't permit you to "push" a value. If you must "push" the value, then you'll have to use code. – ErrCode
Thanks for the assist, I feared that this would be the case. Back to the drawing board. – Chris

1 Answers

0
votes

The cell in the other sheet cannot have the answer and also be blank. You can, however, set the colour of the text to be the same as the background.