how can i link workbooks in excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone offer a suggestion? working with Excel 2000
I have 12 individuals who add data to identical spreadsheets on a daily basis.
I want to have all these spreadsheets feed into an identical Master
spreadsheet automatically.
I have tried Merge but each sheet that I merge just overwrites the previous
one when data is entered to the same rows.
I think I am going to have to set it up with VBA but have not used this
before.
Can anyone offer me some assistance?
 
You should set up the master workbook for sharing, rather than trying to do a
merge. If you did the latter in VBA, how would you monitor and resolve
conflicts?
 
You must log in or register to reply here.

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

Similar Threads

Save record Into master sheet! 1
Open a word mail-merge document from Excel VBA 1
move worksheet to end of another workbook 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Dynamic Workbook in VBA 2
Extract specific data from multiple workbooks to a master file 2
Collate data from multiple workbooks into one worksheet 0

Back
Top