Hi,
I am looking for macro that can copy whole row as value to another sheet as last, based on cell values and delete it after from the original location.
Example: if cell value in column E = "Finalised" AND cell value in column E = "New registration", the whole row to be moved/copied (preferably as values) to the last empty row in Sheet2 (there is another data as well) and also delete the empty row left after.
Thanks in advance
I am looking for macro that can copy whole row as value to another sheet as last, based on cell values and delete it after from the original location.
Example: if cell value in column E = "Finalised" AND cell value in column E = "New registration", the whole row to be moved/copied (preferably as values) to the last empty row in Sheet2 (there is another data as well) and also delete the empty row left after.
Thanks in advance