+ Reply to Thread
Results 1 to 1 of 1

Macro restructuring file

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    I need to make a macro for changing my files format, but I have no idea how to do that one:

    Basically I have all these excel files, and they all have the same format: 7 columns. I want to get rid of 5 columns, and then change the place of some cells.

    The 'What I have' file is an example of file I have.
    I need to keep the columns A and G. Then changing the cells that way: my data are basically each time 3 measurements of 3 individuals (2 males and a female = a trial) within a population. I want the 3 individuals (male 1, male 2, female) of each trial on the same line, but they don't follow each other:

    -> if there are 15 raws in the file, the first 5 are the males '1', the next 5 are the males '2', and the last 5 are the females (if 12 raws: 4 males '1' then 4 males '2' then 4 females) = this is the 'What I would like' file.

    Help please! Is it easy to do? Any tutorial to suggest me?
    I want to basically create a new file I think, for each one, or a new sheet within each file.




    Here is the Excel example. Hope this helps.

    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by davesexcel; 02-28-2011 at 08:03 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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