Show the product of a formula calculated in spreadsheet one in spreadsheet 2

  • Thread starter Thread starter Ronnie
  • Start date Start date
R

Ronnie

I have built a formula into spreadsheet 1 and the product
of that formula is always displayed in, say, D12 of
spreadsheet 1.

I need to be able to simultaneously display the product of
my calculation in spreadsheet 2, say column F. However, I
also need each calculation to appear in the next available
row in climn F spreadsheet 2.

How do I achieve this?
 
I don't think what you want is possible without a macro, and your
requirements need to be clearer. Why don't you just put the formula:

=D12

in the next available row of column F?
 
Back
Top