copy row to new sheet if criteria met

[gilnic]

Hello,
I am hoping someone may be able to assist me with my project please.
In sheet1 I have data which I paste daily in cols A-R which is the heading and cols B-R which has the data, and in Col S and Col T I have formulas which result in placing a”Yes” if criteria is met.
In sheet2 I have data I have data which I paste daily in cols A-R which is the heading and cols B-R which has the data in cols A-R
and in Col S I have a formula which results in placing a”Yes” if criteria is met.
Now what I wish to be able to do is copy the complete row of any from sheet1 ColS , ColT,sheet2 ColS
that have “Yes” entered as a result of the formula into sheet3.

[Winon]

Hello gilnic,

Forum Members do not usually feel inclined to create a Workbook or Sheet to replicate your layout.

Please attach a sample workbook.

Make sure there is just enough data to demonstrate your need.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[gilnic]

Hello Winon,
Thank you for your assistance.
Sample sheet attached. Sheet 1 and 2 has the data and sheet 3 is where I wish to have the rows copied to if criteria met.

[sintek]

Any reason why in Sheet1 your pasted info starts in Column Oval and not under Column Date

If it was copied under the incorrect column...Then this should work...

Please Login or Register  to view this content.

Edit
If it is supposed to be like attached file then a bit more tricky....

Please Login or Register  to view this content.

[gilnic]

Hello sintek,
Thank you for prompt response.For some reason when I copy and paste the table from the website
it ended up as per sheet1 with the data out of line with the headings.I have been trying to correct this and just recently
have improved the copy situation but while the data is aligned with the heading it now leaves Column A blank.
I have attached an updated sample sheet.Of course this is a small sample and the data would normally extends down the rows.
Apologies for messing you around.

[sintek]

Please Login or Register  to view this content.

[gilnic]

Hello Sintek,
Thank you for providing the code for me. This is nearly exactly what I was looking for. When I run the sample there appears to be two differences.
1. It transfers the first row of sheet 1 and sheet 2 to sheet3 even though it does not have “Yes” in the column S in sheet1 or S or T in sheet2.
2. In sheet1 if there is only an entry in column T and not in S it does not transfer the row to sheet3.

[sintek]

Hi gilnic...So are you saying that Sheet1 Col S & Col T (Both) must have "Yes" in before copy over....

[gilnic]

Hello sintek,
Yes" only has to be in either S or T in sheet1 to be copied to sheet3."Yes" can end up being either only in Col S or ColT or it can be in both as per sample2 sheet.
What the code was doing was not transferring the row with "Yes" if it was only in col T.In the sample sheet white and aqua have "Yes" only in col T and they have not been copied.

[jindon]

Try

Please Login or Register  to view this content.

[sintek]

My spin...Not as advanced as jindon...Thankfully this is how we all learn...
A little bit faster I think

Please Login or Register  to view this content.

[jindon]

A little bit faster I think

I don't agree with you.
Just a matter of Screen updating and now mine is a bit faster.

[gilnic]

Hello,
Well there you are,I now have two excellent solutions to my query.
I would like to thank sintek for continued efforts to provide me with the solution I was hoping for.
I would also like to thank jindon for providing me with an alternate solution.

[jindon]

I would also like to thank jindon for providing me with an alternate solution.

I've posted my code just because sintek will not be able to solve the problem, that's all.

[sintek]

just because sintek will not be able to solve the problem

Perhaps....just in case or a better solution which will allow you and sintek both to learn

Thanks gilnic for rep ...Glad we could assist.

[Winon]

@ jidon,

Hello jindon,

I've posted my code just because sintek will not be able to solve the problem, that's all.

Although your assumption might be correct, I believe it was a bit harsh to make such a statement about sintek, as he has kept on trying, and maybe could come up with a workable solution comparable to your outcome of solving the issue.

Granted, you have provided an excellent solution, but so could sintek as well, given the opportunity the further explore his efforts.

Contributors helping each other are welcome, and is in fact encouraged, without belittling the other, unless it is done so with a sense of tongue in the cheek humor.

To both of you, sintek included, keep up the good work!

Regards.