Hi everyone, Im using excel 2007, not very good in VBA and I need your help to create VBA code separate the data in raw data sheet into new sheet based on the certain criteria.
I dont really know how to explain the problem in detail, so to be precise enough, I have attach the sample file for your view to get to know my problem well.
1. All the data will be in sheet "Day1 Raw".
2. Need to separate the data in Column "F" into new sheet("Day1 Reaarrange") based on the trial(column "A"), arena(column"B") and treatment(column"D")
3. Then I need to sort the data into sheet "Sorted data" by summing up every 3 rows of the separated data values.
Condition:
1. Each " Start-0:00:20" remarks start of new arena.
2. Only start to copy data if the value in column "I" is "0". (Yellow colour means start, red means no need to
copy)first 90 cells and then continue back for 180 cells for each arena.
3. Need to repeat this until all data the data have been copied.
4. Number of trial , arena and treatment would not be the same everytime.
Hoping for help![]()
Bookmarks