Copy data.

Hi all,

I need to copy an excel sheet to another book, but the original sheets has combo boxes that look at another sheet for their values.
I need to copy just the selected item in the combo and not the whole list.

How can I do this ?

Thanks in advance,
K.
LVL 10
Kinger247Asked:
Who is Participating?
 
MINDSUPERBCommented:
You may try to copy the whole column where the combobox and then do the paste special values only.

Sincerely,
Ed
0
 
Kinger247Author Commented:
Hi, have tried that but the underlying cell doesnt have any data in it ... so not sure how its holding the selected item in the combo.
0
 
MINDSUPERBCommented:
How about using the a data validation list instead of combo box. However, you need to place the source list within the same worksheet so that you can move it without affecting the data source of the dropdown.

Ed
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
mark_harris231Commented:
Are the ComboBoxes from the Form Controls toolbar or the ActiveX toolbar?  If ActiveX, you can set a Linked Cell reference which will copy the selected ComboBox value to the linked cell, which can then be copied/pasted.
0
 
mark_harris231Commented:
Example of ActiveX ComboBox properties attached as image

CB Properties
0
 
Kinger247Author Commented:
Thanks for all the info, I found out why it wasnt working. It was because the combobox wasnt assigned to a cell. So couldnt get the data out.
But there was nearly 8000 rows, each with a combo item, so I had to create another column and  manually the value selected in there.

Pain in the backside, but a couple of hours later its all done.

thanks for your suggestions,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.