| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data from excel worksheet update with another excel worksheet
Dears
I have create a questionnaire worksheet from excel and let the peoples input the data on every questionaire worksheet. I just want to create a another summary worksheet and collect their data into one worksheet. Would you please tell me how to link up with two excel worksheet. Or using access database instead. thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data from excel worksheet update with another excel worksheet
Tony,
This could be accomplished with a little bit of VBA. -- Regards, Eddie http://www.HelpExcel.com "tonycd" wrote: Dears I have create a questionnaire worksheet from excel and let the peoples input the data on every questionaire worksheet. I just want to create a another summary worksheet and collect their data into one worksheet. Would you please tell me how to link up with two excel worksheet. Or using access database instead. thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data from excel worksheet update with another excel worksheet
Hi Eddie
Do you have any simple so i can follow..Thanks again Tony "HelpExcel.com" wrote: Tony, This could be accomplished with a little bit of VBA. -- Regards, Eddie http://www.HelpExcel.com "tonycd" wrote: Dears I have create a questionnaire worksheet from excel and let the peoples input the data on every questionaire worksheet. I just want to create a another summary worksheet and collect their data into one worksheet. Would you please tell me how to link up with two excel worksheet. Or using access database instead. thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data from excel worksheet update with another excel worksheet
Tony,
You can actually summarize your data without VBA. You can use a formulaic array similar to the following: =sum(if(sheet1!a1:a100="data to be summarized",b1:b100,0)) (press cntrl-shift-enter instead of just enter) You would have to replace some of the variables in this formula to make it specific to your challenge. -- Regards, Eddie http://www.HelpExcel.com "tonycd" wrote: Hi Eddie Do you have any simple so i can follow..Thanks again Tony "HelpExcel.com" wrote: Tony, This could be accomplished with a little bit of VBA. -- Regards, Eddie http://www.HelpExcel.com "tonycd" wrote: Dears I have create a questionnaire worksheet from excel and let the peoples input the data on every questionaire worksheet. I just want to create a another summary worksheet and collect their data into one worksheet. Would you please tell me how to link up with two excel worksheet. Or using access database instead. thanks. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data from excel worksheet update with another excel worksheet
Hi Eddie
May i really confused you. I created a questionnaire worksheet and will send a path to users one by one for answering a question , once the user clicked "save" button on the excel worksheet. The user can "save as" and update the record to some sort of database, (excel worksheet or access database is ok.) Thanks again. regards Tony "HelpExcel.com" wrote: Tony, You can actually summarize your data without VBA. You can use a formulaic array similar to the following: =sum(if(sheet1!a1:a100="data to be summarized",b1:b100,0)) (press cntrl-shift-enter instead of just enter) You would have to replace some of the variables in this formula to make it specific to your challenge. -- Regards, Eddie http://www.HelpExcel.com "tonycd" wrote: Hi Eddie Do you have any simple so i can follow..Thanks again Tony "HelpExcel.com" wrote: Tony, This could be accomplished with a little bit of VBA. -- Regards, Eddie http://www.HelpExcel.com "tonycd" wrote: Dears I have create a questionnaire worksheet from excel and let the peoples input the data on every questionaire worksheet. I just want to create a another summary worksheet and collect their data into one worksheet. Would you please tell me how to link up with two excel worksheet. Or using access database instead. thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I update worksheet 1 from data on worksheet 2 | Excel Worksheet Functions | |||
| can I name an excel worksheet tab by linking to worksheet data? | Excel Worksheet Functions | |||
| how do I link data in an excel worksheet to another worksheet? | Excel Discussion (Misc queries) | |||
| importing data from Excel worksheet to another worksheet | Excel Worksheet Functions | |||
| Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Linear Mode
