Automatically copy a row of data from one sheet to another

[bodi22577]

Hello,

I'd like to learn how to automatically copy a row of data from one sheet to another, only if a specific cell contains specific data. It would have to populate on one sheet but read from multiple sheets in the same workbook.

I.E. if tab 213 has "SOP" in column F, I would like to copy the data from that row and insert it into the SOP tab.

ROUTSHEET.xlsx

[JOHN H. DAVIS]

Hello,

I'd like to learn how to automatically copy a row of data from one sheet to another, only if a specific cell contains specific data. It would have to populate on one sheet but read from multiple sheets in the same workbook.

I.E. if tab 213 has "SOP" in column F, I would like to copy the data from that row and insert it into the SOP tab.

Attachment 291835

Per your PM. Is this what you are trying to do?

Please Login or Register  to view this content.

[bodi22577]

You rock! That works perfect! Thanks so much for your help!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

[bodi22577]

I just had some more time to use it. I noticed every time I run the macro it duplicates the data. Any way to fix that? Also, If I wanted to do the same function for column "G" with the keyword "wait" how would I add that?

Thanks again,
Ryan

[JOHN H. DAVIS]

Do you mean you want to clear the destination sheets first?

Maybe:

Please Login or Register  to view this content.

[bodi22577]

One last thing and it should be perfect... The script clears the top row of the destination sheet, any way to copy that or keep it from clearing?

Again, I really appreciate all of your help.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[bodi22577]

I get an error 400 after copying that last script into my workbook.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[bodi22577]

It still clears the top row, which contains the column headings.

[JOHN H. DAVIS]

Try it now.

Please Login or Register  to view this content.

[bodi22577]

Looks good to me! Thanks again!

[JOHN H. DAVIS]

You're welcome. Glad to help out.