How do I do the following: If rows on one worksheet contain a certain text value, copy certain cells in those rows to another worksheet.

[touch23]

Hello,

I'm new to this forum, but I hope someone can help me. I have a workbook that contains several worksheets. On the second sheet, named Master, I track contract data over 30 columns. Column E notes the status of these contracts as either 'planned,' 'awarded', or 'closed'.

The first worksheet is my dashboard, named 'Home'. This sheet is divided into 4 sections. The top left is in table format and contains active contracts (rows 3-23, with row 3 being headers), the bottom left is in table format and contains planned contracts (rows 25-45, with row 25 being headers).

For contracts noted as 'awarded' on the Master sheet, I would like to copy data found in columns A-D, F-H, O, and Z to the Home sheet, Active Contracts section. For contracts noted as 'planned', I would like to copy data found in columns F, G, D, H, L, P, O, and AC (in this order) to the Planned Contracts table.

If anyone can assist or direct me as to where I can find information on how to do this, I would greatly appreciate it. Please let me know if you have any questions or if more information is required. I can send anyone a mock of my workbook, if needed.

Thanks!

 

[Smitty]

Welcome to the Board!

Please stick to your Original Thread. It helps everyone stay on the same page.