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

Report
Posts
1
Registration date
Sunday February 14, 2021
Status
Member
Last seen
February 14, 2021
-
Posts
1277
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 15, 2021
-
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

1 reply

Posts
1277
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 15, 2021
220
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!