If a column L contains the words "Deleted adjustments" and "Reversal Adjustments" in its comments then copy the whole row to worksheet Deleted Adjs after headings and delete those rows in the previous sheet.
If a column L contains the words "Deleted adjustments" and "Reversal Adjustments" in its comments then copy the whole row to worksheet Deleted Adjs after headings and delete those rows in the previous sheet.
What is the question? I can't understand. Please explain further.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
If in column L cells contain the words "Deleted adjustments" and "Reversal Adjustments" then copy the whole to another sheet and clear it from the previous sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks