update data from one workbook to another

D

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

T. Valko

Try this...

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

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).
 
D

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!
 

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

Top