sajeevjvarma,
Welcome to the Forum.
You need to create a TABLE of the data you want copied. The selection column is the leftmost
column of the TABLE. This could be placed out of view or on another worksheet.
Next you need to create a DATA VALIDATION cell referencing the leftmost column of your TABLE.
This cell could then be copied wherever needed. Where would this cell be?
Then create a Worksheet macro to do the lookup and retrieve from your Table. This could be a
Worksheet_Change so when you do the Data Validation and select a value, the other values are
retrieved according to your TABLE layout.
So that is one method to do what you want. You will get more help if you post a sample of your
data TABLE and where it is located on your worksheet. You can post that using one of these methods shown here:
HTML Maker Installation Instructions
http://www.mrexcel.com/forum/2545970-post2.html
Forum Tools Add-In
https://www.dropbox.com/s/umis204g6eacu7m/Forum Tools.xlam?dl=0
OR...you can post a picture (.jpg image file) by uploading an image of your worksheet to
imgur.com or other image hosting site and then posting the link to that file. It is generally better
to post a sample using the above 2 methods rather than an image so that those helping you don't
have to retype your data, they can just copy and paste. But 'a picture is worth a million words'.
So that should get you started.
Perpa
