update data from one workbook to another

[dalmom]

How would I accomplish this without having both books open and copy/paste
each time?

Workbook 5, sheet 22, column 9 needs to have the data from
Workbook 1, sheet 3, column 2,

Workbook 5 needs to be able to pull the data from workbook 1 and update it
to match when I open the workbook, it needs the entire column of data.

 

[T. Valko]

Try this...

Do this one time...Do your normal copy operation BUT instead of pasting do
Right click>Paste Special>Paste Link.

 

[trip_to_tokyo]

Hi dalmom. I have just put up your 2 (EXCEL 2007) files at:-

www.pierrefondes.com

These will do what you want them to do.

When opening workbook5 you will need to:-

- hit Options (towards top / middle of screen)

- select Enable this content / OK

This will then pull in the info from Workbook 1.

Please hit Yes if my comments have helped you.

(If you do not understand my instructions ask away and I will try and
clarify).

 

[dalmom]

Biff to my rescue again!

Worked perfectly

Copied entire column, Workbook 1, sheet 3, column 2 pasted link to entire
column in Workbook 5, sheet 22, column 9

Simple, to the point, easy to understand!

Thanks again Biff!

 

[T. Valko]

You're welcome. Thanks for the feedback!