Changing value within a cell

[lavppp]

Hello to all,

In sheet1 there are content in column A only (several lines).

A1 content is "baba=1234"
A2 content is "zozo=5678"
Ax content is "something=####"

By the way there wont be 2 lines with the same content.

I would like to scan through the list, find a cell content that starts with zozo (the location of zozo=#### could change within the column A) and change 5678 for the value in cell A1 of sheet 2.

Can you help me? Thank you in advance.

 

[Comfy]

Highlight column A.
Press CTRL & F
Press ALT & P

In Find what type: zozo=5678
In Find what type: zozo=the value you want to replace with

 

[lavppp]

I guess I should have mentioned I would like to do this in a form of a macro because I will have to repeat this excercise 4 times when I open the excel file.

Thanks for your help!