Copying a cell's contents to another worksheet based on text contained in different cell

[cjames83]

Hello! If Cell 1B (sheet 1) contains the word "Pending" or "Yes", it is possible to copy the exact text from Cell 1A (sheet 1) to the next blank cell in Column A (sheet 2)? Thanks for any information!

 

[My Aswer Is This]

My original script may not have been properly written. And now that your wanting more things added to the script I suggest you make a whole new posting explain in detail what you want.

I'd like to see if it's possible to add one more condition which is in red. If column DT (Registration Report) says "pending" or "yes" AND column B (Registration Report) says "Both" or "Non-Scripted" then...

I tried adding the red portion of the following code but it still returned "no" values from the DT column so I obviously didn't write it correctly:

IfSheets("Registration Report").Cells(i, "DT").Value ="Pending" Or Cells(i, "DT").Value = "Yes" andSheets("Registration Report").Cells(i, "B").Value ="Both" Or Cells(i, "B").Value = "Non-Scripted"Then...

Is what I'm looking to do possible?

 

[cjames83]

Thanks