Hi,
I've been able to successfully move rows from one sheet to another based on a cell value in a row using VBA code, but now I can't figure out how to do the same for multiple cell values and different sheets.
This is what I'm trying to do-
If dropdown list selection in Column R after Row 5 = "Active", then move row data from column B to R to destination sheet "Active List" column B after row 4.
if dropdown list selection in Column R after Row 5 = "Inactive", then move row data from column B to R to destination sheet "Inactive List" column B after row 4.
Can you help me? I'm a novice.
I've been able to successfully move rows from one sheet to another based on a cell value in a row using VBA code, but now I can't figure out how to do the same for multiple cell values and different sheets.
This is what I'm trying to do-
If dropdown list selection in Column R after Row 5 = "Active", then move row data from column B to R to destination sheet "Active List" column B after row 4.
if dropdown list selection in Column R after Row 5 = "Inactive", then move row data from column B to R to destination sheet "Inactive List" column B after row 4.
Can you help me? I'm a novice.