Edit Data in Excel

Job ID: 35320158

Budget: $10 – $30 USD

We have a spreadsheet containing our products from our store.

We need someone who is excellent in excel or libre calc to write some kind of script/macro:

Show only rows which have cells that contain a keyword.
Then copy data from column A to column B, and then in the column A show a number which has a value -40% of column A.

That's it.