Hello, im new to macros and was wondering if its possible to re arrange sheet 1 to look like sheet 2 in the file attached. So something like:

If any text string in column A looks like "chain" then put this into cell 1 Column A<--so running something like this should put "Chain: 12345678" into the first cell in column A since thats the only text value on the excel doc with the word "chain in it" (See sheet 2 for reference".


Thanks!goodsample.xlsx