Command Button to initiate Search and copy-paste

Hi,

Something I look forward to simplifying something in my excel sheet.

Two worksheets, Bill and Support. Four cells in worksheet "Support" (Cells are I20, M20, R20, T20) and Four-column in worksheet "Bill" ( I, W, X, Y) which row start from 9 -1220.

If the command button is clicked.

Cell I20 value of "support" search in between Cells I9:I1220 of Bill Worksheet. If match found then M20, R20, and T20 Value paste in the corresponding matched row of W, X, Y. and also popup a massage "value updated".

Thanks in advance.

Hi Moderator,

This is very interesting.

I tried to inform about the cross posting in this thread by providing a link, but your system does not give me permission for provide a link as a new member. So I have to edit it then post.

As I need some solution so posted here. If I got the answer from this forum I definitely pasted other forum about the solution I have got.

I will definatly comply all your forum rules.

Thanks.