Hi,
I have a problem with my data. I am doing biological experiments where I use three or seven individuals for each experiment. I have measured the length (column B) and weight (column C) of each individual. The individuals ID number is in column A. What I need is some automatic way of copying the length and weight from columns B and C to the next sheet, where I have the information about the experiments. There Column A is experiment number and columns B to G are the ID numbers for the individuals used.
I would need to get the length of the individuals to columns H-M and weights to columns N-S. (Weight of individual in column B into column N and length of same individual into column H) Is there a command that would make this easy?