Kinger247
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Ed
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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,
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,
ASKER