Worksheets

M

Marita

:confused: I have 4 worksheets in a file to calculate inventory comin
in and out. I would like to take a colum from worksheet one and plac
the contents into worksheet two automatically. Is there a formula I ca
use that will allow me to take info from one worksheet to another
 
G

Gord Dibben

Marita

You could select the used range of the column and switch to the other sheet
then Paste Special>Paste Link>OK>Esc.

As you add more rows of data to the source sheet, you can drag/copy the link
formula down on target sheet.

Gord Dibben Excel MVP
 
Top