Adding new lines from a 'form'

Hi All

I have created a basic form:
Picture1.jpg

When I click the 'Add to Schedule' button I would like to execute a macro that drops this information into the next available row in this table:
Picture2.jpg

If someone could show me the VB code for getting the information in the 'On Sale' part of the form into the next available row in column C, I am sure I can modify the the coding for the other info!

Thanks!

Try this Function to get the next available row for data entry on any sheet.

Please Login or Register  to view this content.