Results 1 to 3 of 3

VBA to separate data into multiple columns based on certain condition

Threaded View

VBADumb VBA to separate data into... 07-31-2013, 11:25 PM
lotuxel Re: VBA to separate data into... 08-01-2013, 03:07 AM
VBADumb Re: VBA to separate data into... 08-25-2013, 09:41 PM
  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    Kuala Lumpur,Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    2

    VBA to separate data into multiple columns based on certain condition

    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
    Attached Files Attached Files
    Last edited by VBADumb; 07-31-2013 at 11:39 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy/Paste multiple columns as values based on another columns criteria
    By Dgp2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2013, 06:50 AM
  2. Sum data based on multiple criteria across multiple columns
    By lbn7153 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2012, 07:18 AM
  3. Macro to Segregate the data based on Multiple Criteria's in Multiple Columns -Challenging!
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2012, 07:31 AM
  4. Replies: 3
    Last Post: 06-12-2012, 01:33 PM
  5. Replies: 1
    Last Post: 03-01-2012, 09:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1