Macro for copying and inserting a row

[owainbaber]

I have a spreadsheet, an example of which can be viewed in the picture 'excel1.jpg' attached to this post, that i need to format correctly to upload to a webserver to update products. The first row is the database field names with each product below that. This would be fine for most shopping cart software, but mine only imports the first product. After running a few tests i discovered that if i include the database fields (row1) above each individual product it will import fine. So what i need is a macro that will copy and insert the first row above each product, basically so it looks like the picture 'excel2.jpg' attached. The data in the pictures is test data as my spreadsheet has approx 1,500 records. Is there a way to do this? Many thanks.

[Richard Buttrey]

Hi,
Probably the easiest way to do this is as follows.

In a spare column say K, in row 2 enter the value 2, and in row K3 the formula = K2+2.

Now copy this down all 1500 rows and copy and paste special values all these numbers.

Now in a second spare column do the same but in say L2 enter 1, and in L3 =L2+2 and copy these down. Now copy the whole of L2:L1500 and paste special values underneath the last used cell in column K.

Now sort the whole of your data using column K as the primary key to end up with your data distributed on every other row.

Now filter the data for blanks on any column other than K or L and then copy row 1 down all the blank rows.

Finally unfilter your data.

HTH