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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Standar deviation across sheets help 0
Vlookup? 1
linking a sales receipt worksheet to an inventory worksheet 0
Can the IF function be used with values from multiple worksheets? 4
Avoiding redundant calculations 7
90 day Running total 1
Multiply with Vlookup value from another Worksheet 0
Calculate a date based on values in other cell, worksheet 4

Top