Sharing information

[Lynn]

I know how to get information from one spreadsheet to
another by entering = in a cell on one spreadsheet, then
clicking in the other spreadsheet cell to insert the
formula. How can I tell it to formulate a entire row or
column? Also, what if at a later date I need to insert a
row? Will the formula follow through?

Thanks

 

[Frank Kabel]

Hi
you have to copy this formula for all cells you want to 'incluide'

 

[Lynn]

What formula?

Thanks

-----Original Message-----
Hi
you have to copy this formula for all cells you want to 'incluide'

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Frank Kabel]

Hi
the formula you have entered with a starting equation sign

 

[Lynn]

I understand, but isn't there a way I can formulate the
whole column at one time?

 

[Frank Kabel]

Hi
no, not possible with formulas

 

[Gord Dibben]

Lynn

Select the column or range to use in Target Sheet.

Enter = in active cell.

Switch to Source Sheet and click on A1(example)

Hit CRTL + ENTER.

Target Sheet column/range has formulas entered incrementally.

Inserting/deleting rows later is more problematic and would probably require
some manipulation by user.

Gord Dibben Excel MVP