Macro to format data - counting and adding additional rows on condition

Hi,

Have been working on a project requiring mathematical manipulation of data using R/SAS. For some functions the data need to be formatted correctly first, which I was hoping to achieve through a macro.

Wanted to count the number of rows for each 'datekey' (column A) and if <14, then add additional rows with the same datekey until all are 14. Columns C:J on the inserted rows can remain blank (such that the mathematical procedures will omit these as corrupt data).

Limited programming experience - any help pointing in the right direction greatly appreciated!

Cheers

sampledata.xls

Hi,

Try this code in the worksheet module:

Please Login or Register  to view this content.

Regards,

Darzou

excellent! there's an error with invalid use of 'me.' keyword

but if i kill all the instances of 'me.' the code works perfectly

thanks!

The "Me" requires to use the code in the worksheet's module, not a stand alone module. Thus, if you select another worksheet or workbook while the program is still running there won't be any errors.

Darzou