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.
Last edited by davesexcel; 02-28-2011 at 08:03 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1