Hi,

You can perform an "Advanced Auto Filter" in the list in sheet2, based on
the cleint name, and then copy the extracted data to the clipbaord using
Edit-COPY, and paste them in sheet1.

Challa Prabhu

"MadHenry" wrote:

How is it possible to update a price list with another price list from
another sheet according to a client name.. maybe you can understand it in the
picture
www.vahetus.com/up/helponexcel.jpg