VBA code to moving entire row based on value from drop down list

[anhpp72]

Hi all. I was hoping to get your help on this. I have 3 items in my dropdown list: dead, clients, prospects and suspects and 3 corresponding sheets. I want VBA to automatically move the entire rows to the corresponding sheet based on the value selected. I am really new on this so any help will be much appreciated.

 

[PGI_Help]

Please explain in detail what you are trying to accomplish. And give specific sheet names.

Hi - I am looking to run a similar macro to what solved the original issues posted here, but instead of moving an entire row I only want to move the contents of one cell and have that pasted in the same column but at the bottom of a list on a different tab. I have attached an image but on Tab 1 (Need_Sched_Mach) the user would input a Machine Number in column A that is the same number as one of the tabs in the workbook.

Once a machine number is populated in column A, I would like the contents of column C on Tab 1 to be pasted into column C in the first open row on a tab that is named the same as the machine number. For this example, I would put in 205 in A4 and the contents of C4 in Tab1 would be pasted in C8 (Red) on Tab 205.

Please let me know if this is clear or I need to send more information.