Hi gurus
I tried to find my vba requirement from google but could not find exact scenarios in any where. I am assuming my request comes under a sheet event change. The attached workbook already have sheet change macros in it.(I cant claim the credit)
My dilemma is to find an exact answer for my below situation.
I want to cut and paste selected cell range from sheet WiP to Back allocation form, in three different scenarios.
1. If column N is “Completed” and Column AA is “Allocated to TL/Site”, then I need to copy (not cut) the entire row in to sheet named ”Back allocation form” without capturing the contents in column N,O and P
2. If column N is NOT “Completed” and Column AA is “Allocated to TL/Site”, then I need to cut the entire row in to sheet named ”Back allocation form”
3. If column N is “Completed”, column Q is “Completed” and Column X is “Allocated to TL/Site”, then I need to copy (not cut) the entire row in to sheet named ”Back allocation form” without capturing the contents in column N,O,P,Q,R and then U,V and W.
I tried to find this info from google but could not find exact scenarios in any where
Any suggestions please
Bookmarks