| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i link workbooks in excel 2000
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can i link workbooks in excel 2000
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? On Wed, 24 Nov 2004 15:59:03 -0800, "NikNak_1000" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Excel 2000 Shared Workbooks | Excel Worksheet Functions | |||
| Problem with Excel 2000 Shared Workbooks | Excel Discussion (Misc queries) | |||
| Linking problems between two workbooks - Excel 2000 SP3 | Setting up and Configuration of Excel | |||
| worksheets/workbooks in Excel 2000 and or Office2003 | Excel Discussion (Misc queries) | |||
| Removing links to other workbooks-Excel 2000 | Excel Worksheet Functions | |||
Linear Mode
