VBA to copy data into next row on other sheet

[mattmc419]

Hey Guys!

I'm looking to develop VBA to do the following for the attached workbook:

When someone clicks the "Record" button on the 'DSD Calculator' Sheet, I want it to transfer all the relevant data over to the next available row (starting in row 10) to the correct columns on the 'Sales Tracker' sheet.

I'd also like the 'Date' column to automatically fill in with the day's date when the 'Record' button is pressed.

I don't know much VBA, so this part has been a challenge. Any help is greatly appreciated!

Thanks!
Matt

[mattmc419]

After watching some YouTube videos, I got it to work.

Thread Solved

[arlu1201]

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[mattmc419]

Here's the solution I came up with:

Please Login or Register  to view this content.