Hi Martin, will you please at your convenience and if possible to help me with a code: I have data in column B 15000 plus entries. I wish to make it a drop down list with a code that when I enter a word, the list should pop down to the nearest word, and on click it may go on pasting to another column from top to down. I am sorry if not clear but i hope you will understand my question. thanks u always have been of very much help. Flower R
couldnt find it!
Martin, if u have time please look my post in general section about merging cells. Thanks a lot. Flower R