Hello,
I have a workbook with two sheets. One of them is updated monthly with a list of contracts and contract details. However, that sheet is generated automatically by an external program and is quite cluttered and difficult to navigate. My goal is to create a simplified list of every contract in the other sheet.
The issue is that the cluttered sheet displays the names of the contracts in Column B as "CONTRACT NAME: XXXX" whereas I really only want to copy and paste "XXXX". I would greatly appreciate any help in searching Column B for the contract name, copying just the "XXXX" portion, and pasting them subsequently in Column A of the other sheet, starting on Row 12. I hope that makes sense; thank you all very much for any help!
Best,
I have a workbook with two sheets. One of them is updated monthly with a list of contracts and contract details. However, that sheet is generated automatically by an external program and is quite cluttered and difficult to navigate. My goal is to create a simplified list of every contract in the other sheet.
The issue is that the cluttered sheet displays the names of the contracts in Column B as "CONTRACT NAME: XXXX" whereas I really only want to copy and paste "XXXX". I would greatly appreciate any help in searching Column B for the contract name, copying just the "XXXX" portion, and pasting them subsequently in Column A of the other sheet, starting on Row 12. I hope that makes sense; thank you all very much for any help!
Best,