DATA VALIDATION IN REVERSE

[Wayne]

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?

 

[JulieD]

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]

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

 

[JulieD]

Hi Wayne

email it to me at julied_ng at hcts dot net dot au

Cheers
JulieD