Copy data from textbox1 to column A till end of cell data of column B

Hi everyone,

I am stuck with an issue.
I'm creating a program that defines some deadlines to some work and i need to copy the data from textbox1 (company name) till the range of the content data of column B (tasks).
I will put an example what currently the macro gives me:

COLUMN A COLUMN B
TEST COMPANY Submiting Model 22
Payroll validation
Encompass update
Task test
...


And i want to fill the column A with test company till the end of column B data, like this:

TEST COMPANY Submiting Model 22
TEST COMPANY Payroll validation
TEST COMPANY Encompass update
TEST COMPANY Task test

this data should not be copy again when i insert another company with diferents taks, for example, inserting another company with the name "Company test 2" i want the data in this figure:


Column A Column B
TEST COMPANY Submiting Model 22
TEST COMPANY Payroll validation
TEST COMPANY Encompass update
TEST COMPANY Task test
Company test 2 Submiting Model 22
company test 2 Payroll validation
company test 2 Encompass update
Company test 2 Task test


Thanks in advance

Here it is...
I want to copy the data from textbox1 from userform3 to sheet ("Clientes Deadline") till the end of the data from the other columns. Now it is working for the 1st insert. When i insert another company, it will copy from the beggining ("A2") to the end... and i dont want it to replace the previous data...

Thanks!

Originally Posted by arlu1201

Is the text box 3 having its label as Morada?

In which column should the value of that textbox be copied?

The data i want to copy is the Textbox1 in the userform3 havings its label as "Nome da entidade".
The data should be copied to Column A of the sheet "Deadline clientes", till the end of the data from column B of same sheet. However after inserting another company, the data should not replace the previous one.

Thank you.
Regards

Originally Posted by arlu1201

Double click on the Seguinte button and add this code in -

Please Login or Register  to view this content.

Thanks! However with that code, as soon i insert another company, the data from colummn A will be replace with the last company name. This is what are doing assuming i enter another company (called "empresa 2") after i enter a company (called "empresa teste") with the same 4 tasks.

Column A Column B
Empresa 2 Task A
Empresa 2 Task B
Empresa 2 Task C
Empresa 2 Task D
Empresa 2 Task A
Empresa 2 Task B
Empresa 2 Task C
Empresa 2 Task D

I want it that the code gives me this:

Column A Column B
Empresa teste Task A
Empresa teste Task B
Empresa teste Task C
Empresa teste Task D
Empresa 2 Task A
Empresa 2 Task B
Empresa 2 Task C
Empresa 2 Task D

Best regards,