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

Question

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

vcoolio · Answer

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.

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

1 response

Similar discussions

Subscribe To Our Newsletter!