Macro That Automatically Copies Row from Sheet 1 into Sheet 2 Based on Info in that Row

Howdy Excel Forum!

Ha, I apologize off the top for my wordy title... but I've been struggling to figure out how to automatically copy a row of information from Sheet 1 into Sheet 2 if one of the columns in that row contains the text "OKTF." From what I've read, I think I might have to use a macro to accomplish this--and that terrifies me! I think it will be easier to understand if you can see the Excel file, so I've attached it to this post:

WorkListRevised.xlsx

Basically, if (and only if) Column H contains the text "OKTF," I'd like to copy that row automatically to the second sheet ("2nd Visit tracker"). If it's at all possible, I'd like to have Excel copy only Column D (and relocate it to Column A on the second sheet), Column C (and relocate it to column C on the second sheet), and Column B (and relocate it to column D on the second sheet). If that complicated setup wouldn't be possible, I'd be happy just to have the entire row copied.

Now my one concern is that I'd need the macro to not apply to Columns B and E on Sheet 2 (since the information in these columns would be added afterward). In my previous experience with macros, I've noticed that they tend to re-populate the sheets each time you run it--so I worry that once the rows are copied from Sheet 1 to Sheet 2 and the additional information is manually entered into the second sheet, the macro will re-populate the list and throw things out of order. Is there any way to force the macro not to touch the rows it has already copied?

I would be enormously grateful for any help you guys could provide... or even any advice you could offer for how I could achieve my goals here of isolating just the rows with a column containing the text "OKTF."

Thank you very much!!

Michael

Hi Arlette,

Thank you for your response! Regarding your first question: As long as the data is copied onto the second sheet, I would be fine with it either copying instantly or if I had to manually run something to make the copy happen.

I'm a little confused about how to accomplish what you've described, however. For example, how do I re-load Row 2 of Sheet 1 to cause it to copy the new "OKTF" entries onto Sheet 2 (without thing the entries it had previously copied onto Sheet 2)? I would also be willing to add a column to Sheet 1 that had an indicator (e.g., a box with a tick mark) to stop Excel from re-copying those rows. Ha, sadly though, I have no idea how to accomplish that.

Do you think it would be possible to make this work without having to figure out how to write up a macro?

Thank you, again, for your help!

Michael

Arlette,

Thank you for all of your help! I seem to be running into a problem, however, and can't get the macro to actually produce output on the second sheet. For example, on the sheet you attached, I *am* able to run the macro. However, if I add another check ("a") in Column J and run the macro, it doesn't add that information to the second sheet. Do you know what I might be doing wrong?

Thank you!!!!!

Michael

Oy, my bad. This is phenomenal!! You are surely some kind of wizard. Thank you so much for all of your help!!!

Michael