database: Copy data from range excluding blanks plus one cell on another column

Hi, I want to copy data that will be on three columns that may vary depending on the situation, can be between 1 and 13 rows of inputted data. Plus the name of a person taken from a list. There will be two macros, two buttons:

save/modify sale button will copy the data from sheet sales to db, while looking that if the sales Nr. is the same, it will not add a new row, but modify the rest of the column and save a pdf.
copy from range excluding blank cell.xls
new sale will erase the sales data (months, and number of apple boxes), plus take the value of the last contract number and place it on I2

B2 is the name, will always only be one cell.
A6 through A 19 can be the months
B6 through B19 can be the number of apple boxes
C6 through C19 will be the sales number: Sales number will always be a new number with a simple if macro to make it blank (=IF(A6="","",I2+1))


I can make it to copy one line only, but I don't know how to copy the range, and to make the PDF name with the last contract number of the sale.

Why 2 buttons ?

code can see if a sales number excist or not

Please Login or Register  to view this content.

Kind regards
Leo

Hi Leo,

Thank you very much for your help, it seems to be working as intended, amazing!

I needed these two (actually three) buttons because the original sheet also sends an e-mail to both buyer and seller, plus there may be changes that I need to make after I have pressed the button, and it would then update the database.

I tried adding your code to my original workbook, but I got a variable error on "lr = .Range("B" & Rows.Count).End(xlUp).Row"

I've attached the original sheet, also could you maybe explain to me how it works? How do I add new rows, or new cells to be copied? I couldn't quite figure it out

Thanks again for your help man, I really appreciate it.

I tried modifying my first excel sheet that you also worked on, to the look like the one I want to actually use which I attached before. The one I attached before has some VBA codes that might work on mac only and can perhaps do some errors for you. I have attached it here now, I tried the best I could to copy the data I need to the db, but it didn't work - I don't have the knowledge