Dear Experts
I am looking for help with my workbook attachment
I have Repeats prod code in column E:E repeats & single value in that column
i want split E;E column data as Single Time to sheet1 then First Value of Repeat Value to Sheet2
Rest of Repeats Value to Sheet3
Please Find the attachment
FOR E.G
PROD001 REPEAT 3 TIMES in COLUMN E:E
FIRST PROD001 MOVE TO SHEET2
REST 2 PROD001 MOVE TO SHEET3....
ONE TIME VALUE MOVE TO SHEET1.... WITH THE RANGE OF A:N
A few questions -
Once the data is copied to the respective sheets, do you want it to be cleared from the ONSITE sheet?
If there is existing data in Sheet1 - 3 in your file, should it be cleared before running the macro?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks