How to find lastRow for variable columns?

[ImranBhatti]

Hello

I believe that it is possible.But can't figure it out.

I have a userform with 2 commandbuttons "English list" and "Spainish List"
On the worksheet I have
An English List of Hospitals in Column A then in Column B it is in Spainish
An English List of Airlines in Column C then in Column D it is in Spainish
An English List of Banks in Column E then in Column F it is in Spainish

and so on for other lists

I want to click on English List CommandButton and I enter in the add new textbox and if I check the bank then the textbox values should be entered at the last available row of the relevent list in the relevent language,

I know this is a full project but I am not requiring fully prepared application . I just want some help on how can I switch the lists last row.

Please lemme know if you have any questions.

Best Regards
Imran Bhatti