Copy row to another sheet if two (2) criterium are true

Closed
terridw Posts 1 Registration date Sunday February 14, 2021 Status Member Last seen February 14, 2021 - Feb 14, 2021 at 01:24 PM
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - Feb 15, 2021 at 07:31 AM
Hello,

I have a worksheet with seven columns. I need to copy some information to another sheet if b2 is a certain color AND g2 contains contains certain text.
example:

b2 is gray and g2 ="done"
clear contents of sheet "done"
copy and paste to sheet "done"

b2 is purple and g2 ="rti"
clear contents of sheet "fencing"
copy and paste to sheet "fencing"

How do I do this?
Appreciate the help!

System Configuration: Windows / Chrome 88.0.4324.150
Related:

1 response

vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
Feb 15, 2021 at 07:31 AM
Hello Terridw,

I suspect that you have a number of worksheets to which you would like data transferred from a master or main worksheet so this would mean that you have a number of different text values in Column G.

To make it easier for us to help you, we need you to help us so could you please upload a sample of your workbook to a free file sharing site such as WeTransfer or Drop Box then post the link to your file back here.

Please make sure that the sample is an exact replica of your actual workbook showing all worksheets with the inputs shown on the master worksheet and the expected outputs in the destination worksheets. You can do this manually with just a dozen or so rows of input data. If your data is sensitive then please use dummy data.

We should then be able to help you.

Cheerio,
vcoolio.