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,
LVL 10
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You may try to copy the whole column where the combobox and then do the paste special values only.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
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.

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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.
Example of ActiveX ComboBox properties attached as image

CB Properties
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,
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.