How to move a row to the next sheet when I input a certain value in a cell within that row?

[jdlerry]

NEED HELP PLEASE. Thank you! I actually asked the same question before which is VBA codes. If someone can help me with the VBA code please.

 

[jdlerry]

It is an event trigger code. See image below. You need to double-click the Masterlist worksheet and paste the code there. No need to Insert Module or anything

I cannot find that view (very new into this) but attached is my view. So I think it partially worked, since it got deleted in the MASTERLIST tab. But I am not seeing it to the supposed destination. Thank you for your help!

 

[Zot]

I cannot find that view (very new into this) but attached is my view. So I think it partially worked, since it got deleted in the MASTERLIST tab. But I am not seeing it to the supposed destination. Thank you for your help!

On that General, use drop down to select Worksheet. On the right dropdown should be Change.

Under View you can select Project Explorer

 

[jdlerry]

Y

It is an event trigger code. See image below. You need to double-click the Masterlist worksheet and paste the code there. No need to Insert Module or anything

On that General, use drop down to select Worksheet. On the right dropdown should be Change.

Under View you can select Project Explorer

Okay, I got that and I am seeing some progress. When I hit ENTER it got deleted and routed me to the destination tab but the problem is, it did not copy anything. It's juts blank. You might want to check again this file since I updated the tab with the heading similar to the MASTERLIST tab https://www.dropbox.com/s/0fy2uokch6fmfqk/eMedical-Tracker-updated.xlsm?dl=0
Probably that is the problem,

 

[Zot]

Y


Okay, I got that and I am seeing some progress. When I hit ENTER it got deleted and routed me to the destination tab but the problem is, it did not copy anything. It's juts blank. You might want to check again this file since I updated the tab with the heading similar to the MASTERLIST tab https://www.dropbox.com/s/0fy2uokch6fmfqk/eMedical-Tracker-updated.xlsm?dl=0
Probably that is the problem,

Actually, when you select any item from drop down list, it will trigger the macro. It is worksheet Change event. No need to press Enter at all.

Are you sure you have the code under Masterlist worksheet. Refer the sheet name, not Sheet3 since it can be anything. If still nothing happened. Save the file as xlsm (if not macro will get stripped off. Then open the file again to try run

 

[Zot]

I just downloaded the file. You installed it under Module. This will not trigger.

Remove Module1, 2 3, etc. No use.

It should work. I have tested with my mock up data.

Ohh wait. I see that you now have other sheet with header. The writing should start on row 4. I need to change the way the next empty row

 

[Zot]

Change the Function rowNext to this

Function rowNext(ws As Worksheet) As Long
rowNext = ws.Cells(Rows.Count, "A").End(xlUp).Row + 1
If rowNext < 4 Then rowNext = 4
End Function

 

[jdlerry]

Change the Function rowNext to this

Function rowNext(ws As Worksheet) As Long
rowNext = ws.Cells(Rows.Count, "A").End(xlUp).Row + 1
If rowNext < 4 Then rowNext = 4
End Function

FINALLY! It is working. Thank you! But not so perfect. So as you can see, row 4 was already moved to the supposed destination. Questions:
1. How do you not leave a space? Like, the succeeding items should move up automatically and not leave a space.
2. On the screenshot, the rows 5 and onwards, are not working. It's not moving to another tab.

 

[Zot]

FINALLY! It is working. Thank you! But not so perfect. So as you can see, row 4 was already moved to the supposed destination. Questions:
1. How do you not leave a space? Like, the succeeding items should move up automatically and not leave a space.
2. On the screenshot, the rows 5 and onwards, are not working. It's not moving to another tab.

So, you mean the Masterlist will have rows of data. Once the row 4 is moved to other sheet, the remaining data need to shift up.

If that is so, you can just put command to delete the row instead of just ClearContents

 

[Zot]

No .. I cannot do that because you have drop down selection in that row. Let me see what is the best way

 

[jdlerry]

H

So, you mean the Masterlist will have rows of data. Once the row 4 is moved to other sheet, the remaining data need to shift up.

If that is so, you can just put command to delete the row instead of just ClearContents

How do I do that?