LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 788
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating sheets in Workbook from main sheet IMS Lori Excel Discussion (Misc queries) 0 January 28th 08 07:11 PM
How do I capture info from multiple sheets to main worksheet? cempire5 Excel Discussion (Misc queries) 5 September 13th 07 03:36 AM
LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS SSJ New Users to Excel 2 July 9th 07 03:13 AM
How do I combine data from several sheets into one main sheet? Caren F Excel Worksheet Functions 0 April 19th 06 06:39 PM
Macro to link Sheets to main workbook raven_guy Excel Discussion (Misc queries) 0 June 24th 05 12:36 PM


All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"