http://www.excelforum.com/excel-gene...14#post3403914

I have a question similar to the one posted in the above thread. I have a file in which each row of data has 25 timepoints with 66 columns of data each. There are additional columns with data that only is entered once

The macro which solved the above problem dealt with 3 timepoints with 3 columns of data each. I only know some rudimentary VBA. I'm wondering how to edit the macro for use with my data.

i.e. 1. Where in the macro does it specify the number of columns at the beginning do not repeat?
2. Where in the macro does it specify the number of timepoints.
3. Where in the macro does it specify the number of columns per timepoint.

The example posted in that thread, with the macro, are in this file:
sample.xlsm

I am new to this forum, so please forgive me if I have not followed the rules for linking to previous posts or solutions.

Meira Bracha



I don't know enough vba to tell me how do edit the macro. Could you tell me what needs to be changed? Thanks in advance.