Populate next row on button click

[bangorgav]

Hi guys,

Having a complete pickle!

So i have Data in a sheet about cars and their owners including Registration, Car make/model, Owner name, Event attended.

This data will be entered by the user and on button click i want the data to go into another sheet to collect the data together (for example the first row on the new collector sheet will contain,

A B C D
Vauxhall Astra, John Smith, REG123, Classic Car Show.

and on the next button click i want to populate

A2,B2,C2,D2 then
A3,B3,C3,D3 and so on

i've read a few threads about people using a "NextRow" variable but just can't get my head around it...

Thanks for reading!

Gavin.

[arlu1201]

Where will the data be entered?

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[bangorgav]

Firstly, Thanks for getting back to me!

Secondly , unfortunatly not as im in work!

The data is being entered just in cells on the first sheet but in different parts, so im placing each cell into the collector sheet individually like this

sheet5.range("A1")=sheet4.range("k3").text (Car Make)
sheet5.range("B1")=sheet4.range("L3").text (Name)

this will be on the button click but what i want is that each button click it will change from..

1st

sheet5.range("A1")=sheet4.range("k3").text (Car Make)
sheet5.range("B1")=sheet4.range("L3").text (Name)

2nd

sheet5.range("A2")=sheet4.range("k3").text (Car Make)
sheet5.range("B2")=sheet4.range("L3").text (Name)


3rd

sheet5.range("A3")=sheet4.range("k3").text (Car Make)
sheet5.range("B3")=sheet4.range("L3").text (Name)


Thanks again.

[arlu1201]

Try this

Please Login or Register  to view this content.

or you can try this way -

Please Login or Register  to view this content.