Hello everyone
Thanks in advance for taking the time to read my post and for any assistance offered.
I have 3 sheets in a workbook (source sheet - successful sheet - Unsuccessful sheet)
Issue: I need to write a macro that will Transfer six columns of data if a condition is met. The condition is "Y" in column K in source sheet. If "Y" exist in Column K then Transfer the Columns from column A to column F & M to the Columns from column A to column G in successful sheet ... and If "Y" does not exist in column k then Transfer the Columns from column A to column J & M to the Columns from column A to column K in Unsuccessful sheet.
I have tried to write a macro but have had no success.Please have a look at the sample workbook ... If possible I need to avoid loops as original data is too large
I really appreciate your help in this regard.Thanks a lot
Bookmarks