How do i Link and Update 2 different workbooks which have the same column headings?

Originally Posted by ddd23

Hi,
I want a spreadsheet in one workbook linked to another workbook in a different location. When i update one spreadsheet i also want the other spreadsheet to update. The name of the colums in both workbooks are the same.

Any ideas of how i can achieve this?

Your help will be much appreciated?

Thanks

Dee

Hi,

David McRitchie has details on linking worksheets/Workbooks at http://www.mvps.org/dmcritchie/excel/sheets.htm

hth
---