User form code issues

I am having a problem getting the dose to find the proper column.

My data set is a Table "PutterTBL", starting in column AE:AO. For some reason my code does not find the first empty row in column 30.

Another related question the last 2 columns in my table are formulas that I need to be sure copy down with each new entry. What is the best way to accomplish this?

The formulas I need to copy down in column 40 & 41,

Please Login or Register  to view this content.

in column 40,

Please Login or Register  to view this content.

in column 41.

The code for the form entry,

Please Login or Register  to view this content.

I have not entered any code for the formulas as I was unsure how to proceed.

Thanks,
Jim O

It appears to be working mow with the exception of the formula for column 41. For some reason it does not copy down. The yes, no formula copies down (column 40) but not the second formula. Any thoughts?

Jim O

A problem I seem to be running into is that if some of the columns prior to column 31 contain data, the code sees it and wants to insert the new data on the next blank row, even if that row is outside the data set. I need to ignore any data except for data in the data set range.

Jim O

I just need to find a way to limit the initial search for the first blank row to ONLY the data set (columns 31 - 39) and ignore anything else that may be on the worksheet. So far I have been unable to accomplish this.

Jim O

Still looking for a solution to my issue. I have attached a non-functional example to show the king of thing I am dealing with.

With 2 tables or a table and misc. data as shown, I am having a problem getting the code to find the first blank row on the sheet in the appropriate column. If I were to apply the code as I have shown, entries would not start row 11 for table A or row 6 for table B. They will start in row 14 or greater.

I may not be explaining this as well as I should but I think you can see my problem.

I need to specify the proper column to search for each userform (table) and I have no idea how to go about this.

Jim O

Still unable to get this to work properly.

In the latest attempt I am able to locate the proper column but instead of filling the first blank row it wants to fill the row above the last row with data.

Here is the code,

Private Sub CommandButton1_Click()

Please Login or Register  to view this content.

Jim O