12 Sheets - Submit to One Main Spreadsheet
 

Hi All,

I have a spreadsheet where data has to be inputted from 12 users.
Each user will have a blank copy of the spreadsheet, who will in turn fill it.

At the top I have 7 coloums across the top (row 1)
each colum has a name e.g

Date | Name | Problem | Call Length etc..


I would like for the data entered underneth to be saved into another
spreedsheet, maybe in such a way that when some1 from the team clicks the
button it fills up the main spredsheet with there results..

the spredsheet a user should fill in should look somthing like this:


Date | Name | Problem | Call Length
09.2008 Chris Error 1min
09.2008 John Error 2mins


any help would be great!


Cheers
Chris

12 Sheets - Submit to One Main Spreadsheet
 

Sorry, Im using Excel 2003 by the way :)

12 Sheets - Submit to One Main Spreadsheet
 

Hi Chris

Copy the files in one folder and try the merge addd -in
http://www.rondebruin.nl/merge.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chris" wrote in message ...
Hi All,

I have a spreadsheet where data has to be inputted from 12 users.
Each user will have a blank copy of the spreadsheet, who will in turn fill it.

At the top I have 7 coloums across the top (row 1)
each colum has a name e.g

Date | Name | Problem | Call Length etc..


I would like for the data entered underneth to be saved into another
spreedsheet, maybe in such a way that when some1 from the team clicks the
button it fills up the main spredsheet with there results..

the spredsheet a user should fill in should look somthing like this:


Date | Name | Problem | Call Length
09.2008 Chris Error 1min
09.2008 John Error 2mins


any help would be great!


Cheers
Chris