perbags
06-17-2010, 03:23 AM
Hello
Can anyone help with this as I new to Excel VBA .
What I need is Macro that will look though my ‘sheet1’, check column ‘M’ starting on row ’A7’ for the word “unresolved”, if true copy the row range A:P to ‘sheet2’, find the next available empty row starting on range ‘A7’. Then to go back to ‘Sheet1’ and delete the data that was copied.
The data that is being copied is from a drop down list's so I dont know if this will make any differance to the macro....
Thank you to anyone that can help me with this….
Regards
Perbags
Can anyone help with this as I new to Excel VBA .
What I need is Macro that will look though my ‘sheet1’, check column ‘M’ starting on row ’A7’ for the word “unresolved”, if true copy the row range A:P to ‘sheet2’, find the next available empty row starting on range ‘A7’. Then to go back to ‘Sheet1’ and delete the data that was copied.
The data that is being copied is from a drop down list's so I dont know if this will make any differance to the macro....
Thank you to anyone that can help me with this….
Regards
Perbags