Need Userform to Write to Multiple Sheets with Different Offset Criteria

Hi all,

I've been searching around for some help on this for a while but haven't come up with anything yet that is working. I currently have a userform set to enter data on potential business partners for our sales team into the next available row on one worksheet. However, I am looking to further automate the workbook by entering this data not only into the primary table, but also into a separate sheet in the same workbook that is using dynamic ranges to add to, sort, and repopulate a combobox on a separate userform showing appointments with existing business partners (as the new partners would be after being entered originally).

That's a rather long-winded explanation of the intent, and the functionality of all but one of these pieces is already worked out. The wall I'm hitting (and I'm sure it's one of my own making) is that I can write to one worksheet in a next available row format--as intended, since each entry must be placed on its own unique row regardless of which userform it's coming from--but I cannot get the form to write to a separate worksheet selecting the next available cell in a column. The reason the second worksheet must be written by column is that we have different numbers of partners in separate regions, and each region has (by necessity of size) its own column.

I had intended to enter data uniformly in the first worksheet on the next available row regardless of region. The entry on the second worksheet is to be determined by the value of AreaOptionButton1 (True goes to the next available cell in column A), AreaOptionButton2 (True goes to the next available cell in column B), and AreaOptionButton3 (True goes to the next available cell in column C).

The functioning code I currently have for the first worksheet is as follows:

Please Login or Register  to view this content.

Any help would be greatly appreciated (and your patience in reading through this rambling request is already very appreciated as well). I'm just annoyed to have come so far in this and then to hit a wall on something that should be so simple.

Perfect, thanks!