copy data and add a new line (it only does it for 2 rows, after that it overwrites row 2)

[lespring]

Hi.

I am trying to make/edit a macro that allows me to copy data from a input sheet "indtastningsark" and send it to the "data" sheet.

It works with when i push the macro button the first two times, but after that it just overwrites the 2nd line.

The code is as follows:

Please Login or Register  to view this content.

A3 -> V3 works fine (the 22 fields from B7:B28 are covered here)
A4 -> V4 gets overwritten each time.

I have uploaded it here

http://www.sendspace.com/file/b4xm36

The idea is to send the data from "b7 to b28" to the "data" sheet by pushing the button. It works the first two times, but then it just overwrites the second line.

Do you have an idea what could be wrong?

Hope you can help

Thank you in advance

[[email protected]]

Hi,

Does cell B7 gets blank at third run?

Coudl you please upload the sample worksheet.

[lespring]

B7 does not go blank no.

I have uploaded it here

http://www.sendspace.com/file/b4xm36

Is there a other place which is better for uploading or is it fine there?

[[email protected]]

Hi,

In the "Data" sheet, you have formated the first two rows as table. I think thats the issue. Remove the table format of first two rows and macro will run properly.

Rest code is fine, however I would prefer the below code. Please check the attached sheet.

Please Login or Register  to view this content.

[davesexcel]

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

[lespring]

Thank you very much!