I need help with my macro. I've got a table of data A1:R35 in sheet "Active" and when the value in column R is 100% and you press this button I want it to copy and paste that whole row into the next available row in sheet "Completed".
Here is my current Macro:
would like to know how can I execute reverse look up or index match using vba macro?
My worksheet looks like this:
Row Column A Column B Column C
1 Process Subprocess Ref. Indicator
2 Reporting Statutory FO/RM
how can I achieve deleting the entire row based on a text starting with letter "X"
actually, I already have the code below from my previous inquiry and I just forgot to include this particular requirement. is there any way to embed the missing function?
Dim Rng As Range...