Collect data from drop-down list from multiple workbooks.
Closed
Natasyamn
Posts
4
Registration date
Monday April 14, 2014
Status
Member
Last seen
April 17, 2014
-
Apr 16, 2014 at 04:15 AM
Natasyamn Posts 4 Registration date Monday April 14, 2014 Status Member Last seen April 17, 2014 - Apr 17, 2014 at 11:35 PM
Natasyamn Posts 4 Registration date Monday April 14, 2014 Status Member Last seen April 17, 2014 - Apr 17, 2014 at 11:35 PM
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?
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?
Related:
- Collect data from drop-down list from multiple workbooks.
- Display two columns in data validation list but return only one - Guide
- Counter strike 1.6 cheats list - Guide
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Amd crossfire gpu list - Guide
1 response
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?
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?
Apr 17, 2014 at 04:06 AM
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.
Apr 17, 2014 at 09:08 AM
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.
Apr 17, 2014 at 11:35 PM
Thank you so much for helping me. Really appreciate it!