DATA VALIDATION IN REVERSE
If I have a drop-down menu in my Excel spreadsheet, how can
I copy all of the data in this drop-down menu, and paste it into/onto either a normal Excel spreadsheet cells, or even on to a word file? |
Hi Wayne
depends how you created the drop down list - as you mentioned data / validation i'll assume that your list is a data / validation list that you typed into the source field - if so, click in a cell with the drop down list and choose data / validation click in the source box and use CONTROL & C to copy the information go to a blank cell somewhere or your word document and paste in excel the data will appear as a comma separated list, to split it up into different cells, click on the list, choose data / text to columns, choose delimited, next, untick tab, tick comma - finish in word, select your comma separated list, choose table, convert, text to table, choose comma click OK Cheers JulieD "Wayne" wrote in message ... If I have a drop-down menu in my Excel spreadsheet, how can I copy all of the data in this drop-down menu, and paste it into/onto either a normal Excel spreadsheet cells, or even on to a word file? |
I was not able to do what I wanted to do. If this is a
valid email, or perhaps with one that is, could I send you the one and one only page (in html) that I am trying to extract the data from a cell, and paste on seperate lines on my Excel spreadsheets. I do statistics for sports, so you'll understand when I send it. If not, I'll ask thru the Forum. but I'd luvvv to get this right. Thank you for your input and your time in posting a reply to my query, anyway. Wayne |
Hi Wayne
email it to me at julied_ng at hcts dot net dot au Cheers JulieD "Wayne" wrote in message ... I was not able to do what I wanted to do. If this is a valid email, or perhaps with one that is, could I send you the one and one only page (in html) that I am trying to extract the data from a cell, and paste on seperate lines on my Excel spreadsheets. I do statistics for sports, so you'll understand when I send it. If not, I'll ask thru the Forum. but I'd luvvv to get this right. Thank you for your input and your time in posting a reply to my query, anyway. Wayne |
All times are GMT +1. The time now is 05:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com