How to link a field in an excel document to another excel document

[marlun]

Hi!!
I have two different excel dokuments. I want to link fields between the docs. In document A i fill in a number of columns (text, numbers, currency), and i want some of the columns to be copied into document B.

How do I do that

please help

/marlun

 

[Wray69]

If you are wanting to copy the entire column it would be an array formula like such; =[A]Sheet1!$B:$B (the [A] being the name of the workbook you are copying the column from) When you enter the formula be sure to select the entire column in workbook B where you want the result to show. And to activate an array formula you must hit CTRL+SHIFT+ENTER at teh end of the formula line.

Hope this helps.

Regards,

Wray

 

[Dreamboat]

Could be as easy as copying the cells from Doc A, go to Doc B and hit Edit-Paste special-Paste link.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[marlun]

hmm. doesn't work. All I get is the =[CopyInLeverans]Sheet1!$A2:$A6 in the field. How do I write the Sheet!$B:$B, so that it works. I want to copy the A column. Does it copy only the fields that have been filled in???

many thanks for your help

 

[Dreamboat]

What else do you have on your 2nd sheet?

Would it be easier if you copy your entire worksheet as sheet 2 and then delete stuff from it?

Sorry...not quite understanding what you're doing. You said LINK, I gave you LINK.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[Wray69]

If you want the emtire column it should look like this =[CopyInLeverans]Sheet1!$A:$A after entering the formula hit CTRL+SHIFT+ENTER to make it and array (it will look like this in the formula bar
{=[CopyInLeverans]Sheet1!$A:$A }

Or you could take Dreamboats suggestion of copying the cells from Doc A, go to Doc B and hit Edit-Paste special-Paste link. which should do the same thing and is alot easier.

Regards,

Wray