data from excel worksheet update with another excel worksheet

T

tonycd

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.
 
H

HelpExcel.com

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.
 
T

tonycd

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
 

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

Top