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!