Collect data from drop-down list from multiple workbooks. [Closed]

Report
Posts
4
Registration date
Monday April 14, 2014
Status
Member
Last seen
April 17, 2014
-
Posts
4
Registration date
Monday April 14, 2014
Status
Member
Last seen
April 17, 2014
-
Hello!

I have a question. Let say, I have workbook 1 (WB1), workbook 2 (WB2) and workbook 3 (WB3). All basically are the same workbook, just that I give WB1 to Person A, WB2 to Person B and WB3 to Person C. These workbooks contain the same set of questions that they need to choose the answer from the drop-down list that I've prepared.
So, my question. Is it possible to collect the data according to the choices into one big data without having to count them one by one? Like question 1, 2 persons choose answer 1 and one person choose answer 3. Question 2, 3 so on..

is this possible?

1 reply


To answer your question in a sentance, "yes, with software only physical things are limited".

Have you ever constructed a drop down in a VB form before? You really have to manually and statically construct a drop down first. This way, you have an example to reverse engineer.

So, let us know where you are stuck, OK?


Posts
4
Registration date
Monday April 14, 2014
Status
Member
Last seen
April 17, 2014

Hi, ac3mark!

I am truly sorry if I am being really annoying right now, but I really don't understand anything you said.

OK, let me go step by step. Are you saying that in order to collect the data from the drop down list from multiple worksheets, I have to use VBA form? I googled VB form and the results are VBA form. So VB form is a VBA form?

I am sorry, but can you explain it to me like I'm 5 because I'm new to this.
And thank you for replying to my question.
Blocked Profile
yea, VBA is the same. Do you have th edrop down constructed? Where is data being deposited?

You will stil have to manually link all of the sheets together, back into a book, unless you are going to use OLE (object linking and embedding). Have you read on how to create, edit, and control OLE objects. Once you link them all together, you can use count, or countif.
Posts
4
Registration date
Monday April 14, 2014
Status
Member
Last seen
April 17, 2014

Okay, I kind of get the idea of it. I already read about OLE and I think I can figure it out. I think I would be okay.
Thank you so much for helping me. Really appreciate it!