Find,copy and paste

[Majharul Hannan]

Hi, I have big problem. Every day i have to find,copy and paste a lot of data. How can i find them at time and copy them at time.

Suppose there are thousand of customer id .I want to find the Customer Id 45,386.3377,227 and so on.

I want find At a time and copy it at time. how it is possible? Thank

 

[stnkynts]

Please be more specific on what you want to happen. There is no reference.

 

[Majharul Hannan]

<table border="0" cellpadding="0" cellspacing="0" width="288"><col style="width: 77pt;" width="102"> <col style="width: 62pt;" width="82"> <col style="width: 78pt;" width="104"> <tbody><tr style="height: 13.8pt;" height="18"> <td style="height: 13.8pt; width: 77pt;" height="18" width="102">Customer Name</td> <td style="width: 62pt;" width="82">Customer ID</td> <td style="width: 78pt;" width="104">Deliver Oder No</td> </tr> <tr style="height: 13.8pt;" height="18"> <td style="height: 13.8pt;" height="18">Nuzrul</td> <td align="right">12</td> <td align="right">123456</td> </tr> <tr style="height: 13.8pt;" height="18"> <td style="height: 13.8pt;" height="18">Ruuhul</td> <td align="right">32</td> <td align="right">654321</td> </tr> <tr style="height: 13.8pt;" height="18"> <td style="height: 13.8pt;" height="18">Mogid</td> <td align="right">39</td> <td align="right">234561</td> </tr> <tr style="height: 13.8pt;" height="18"> <td style="height: 13.8pt;" height="18">Majhar</td> <td align="right">90</td> <td align="right">345621</td> </tr> <tr style="height: 13.8pt;" height="18"> <td style="height: 13.8pt;" height="18">Mokol</td> <td align="right">34</td> <td align="right">456321</td> </tr> <tr style="height: 13.8pt;" height="18"> <td style="height: 13.8pt;" height="18">Monte</td> <td align="right">24</td> <td align="right">564321</td> </tr> <tr style="height: 13.8pt;" height="18"> <td style="height: 13.8pt;" height="18">Ananr</td> <td align="right">26</td> <td align="right">612345</td> </tr> </tbody></table>





If i want to find these Delivery order no
123456,654321,234561,564321 at a time from the worksheet by one time.(Not one by one)

and copy all the data at a time.

 

[stnkynts]

I am even more confused. Your original post said you wanted to find the "Customer Id". Your most recent post said you want to find the "Delivery order no". Which one is it?

What do you want to do after its copied? Do you want it pasted anywhere or just copied?

You didnt specify which column the data is in. Is it safe to assume that Customer ID is in column CY?

What do you mean by "Not one by one"? What is the difference between copying one by one and all at once as long as the end result is the same?

The picture you attempted to attach is not viewable.

It appears there is a communication barrier due to lack of knowledge of the english language. I am sorry for that. Without proper information I doubt anyone is going to be able to assist you.

 

[Majharul Hannan]

Thank you. It is my fault that i couldn't give too much details. Now i am giving the detail.

Actually every day i need to find the customer name and their details(Customer id, Customer Address) against the delivery order no (from a worksheet) .I usually do this by pressing Ctrl+F. Then give the delivery order no. Go to the Cell. Copy the customer name and details. paste them another worksheet. By this process i can search or find only one customer details.This process is too much time consuming.

the "Customer Name" in the Column "A"."Customer id "B", Customer Address "C" and delivery order no in the Column "D".
I want

1.search several customer details against their delivery order no.