Linking all column values from spreadsheet to spreadsheet

[tudor30]

I know how to link a spreadsheet one value at a time.

example: ='[S350 T3 PLPDP.xls]Master Tracking'!$B$10

Is there a method to link all values in column B to my new worksheet rather than going one cell at a time?

Thanks for the assistance,
John

 

[bluedragon2]

='[S350 T3 PLPDP.xls]Master Tracking'!B1

Then copy down. The $ makes the cell reference absolute. By taking them out, you can copy down with the offset following.





[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

John,

Are you REALLY linking "all the cells in column b"???

Anyhow, copy the forumla (your example is an ABSOLUTE reference and will not do what you want)

So if the formula in B1 is...
[tt]
='[S350 T3 PLPDP.xls]Master Tracking'!B1
[/tt]
1) Copy the formula

2) Select the target range (COLUMN B???)

3) Edit/Paste Special - Formulas

VOLA!

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884