Paste data on next available row

[Pauydaturk]

Hi all,

I'm running a macro to copy data from a form I've created to the master worksheet that is located within the workbook. I've tried for hours to make this macro run how I'd like and am on the verge of giving up, but thought I'd ask(Beg) for help first.

I've had so many unsuccessful revisions that I went back to the drawing board and recorded the macro fresh as listed below. The ultimate goal is to be able to have the locations that are being pasted (Row 8) be incremented to the next row each time the macro runs. Any help is greatly appreciated. The code I'm using is below.

Turk

Please Login or Register  to view this content.

[xladept]

Hi Pauay,

Welcome to the Forum

I'm guessing:

Please Login or Register  to view this content.

[Pauydaturk]

Sadly this didn't work. I received an error: Method 'Range' of object'_Worksheet' failed.

Also your reply made me realize I missed an L in my name... Should have been Paulydaturk...

[Pauydaturk]

OOPs... Forgot to say. Thanks for the quick reply. I really appreciate any assistance I can get on this.

[xladept]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic


AND _ Thanks for the rep!

[Pauydaturk]

So I've attached the work book.

The goal is to fill out the form in worksheet Enter new Data and have it paste across to the appropriate cells in the Concessions tab.

Let me know if you can make heads or tails of it.

SE Concession tracking.xlsx

[xladept]

Try this:

Please Login or Register  to view this content.

[Pauydaturk]

Just got back to the office and tried your code. I adjusted it slightly because it was moving 2 lines down but it worked! Thansk for the assistance, xladept! Made what could have been a frustrating Monday morning much more bearable.

[xladept]

You're welcome!