Find invoice and fill name accordingly using vba

[Kamal GKJ]

Dear ALL,

Hope you are doing good, I have a dump of data (invoice number's) and multiple data in excel. If there are 10 employee's but each can process different number's of invoice's. Here is what I want to do.

If a person is handling the invoice while taking the invoice he should enter his name(VBA sheet or form) and the name should be amended on the respective column against to the invoice number.

Eg O/P
Invoice number Agent name
12345 XXXX
14567 TTTTT
23567 RRRR
19635 LLLLL

Thanks in advance.

 

[Kamal GKJ]

Dear Friends,

Is it possible to produce data as such.

 

[My Aswer Is This]

I looked at this question yesterday. But did not understand what you want.

You gave no sheet names.
You did not mention what columns we are dealing with.​

I see no specific details.

 

[Kamal GKJ]

I looked at this question yesterday. But did not understand what you want.

You gave no sheet names.
You did not mention what columns we are dealing with.​

I see no specific details.

I am working on an excel file which has a dump of invoices data and i require the name of the person who handles the data in the next column.

But the name should be entered by the employee by them self on the form or box by just finding the invoice number.

 

[Kamal GKJ]

For Example)

If take I have Invoices number on column number "A" And want the employee name to be displayed in column "B".

[TABLE="class: outer_border, width: 500, align: center"]
<tbody>[TR]
[TD]Invoice Number[/TD]
[TD]Name of the employee[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]YYYYYYY[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: outer_border, width: 500, align: center"]
<tbody>[TR]
[TD]Enter Invoice Number[/TD]
[TD]XXXXXXX[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Enter Your Name[/TD]
[TD]YYYYYYYY[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Here as the employee name is entered the name in table the name should come against the invoice number.

 

[My Aswer Is This]

Are you saying you have a list of names in Column A
And a list of employee names in Column B


Now when you enter a employee named in Column 1 of a Table the invoice number should be entered in column 2 of the table?

If we are dealing with Tables then I need the Table name

A Table and a Worksheet are not the same.

A Table is a Table on a worksheet and may be any place on the worksheet.

A Table may not always start on column A

Tables columns are referred to like Table1 column 1 or Table1 column 2

 

[Kamal GKJ]

Are you saying you have a list of names in Column A
And a list of employee names in Column B


Now when you enter a employee named in Column 1 of a Table the invoice number should be entered in column 2 of the table?

If we are dealing with Tables then I need the Table name

A Table and a Worksheet are not the same.

A Table is a Table on a worksheet and may be any place on the worksheet.

A Table may not always start on column A

Tables columns are referred to like Table1 column 1 or Table1 column 2

No you'r getting it wrong.

I Have list of Invoices in Column A and names should be entered automatically form the form.

the name should be from the form.

 

[My Aswer Is This]

You said:

names should be entered automatically form the form.​

What is a form?
Do you mean UserForm?

And nothing normally happens automatically when using Excel.
And what names?

 

[Kamal GKJ]

You said:

names should be entered automatically form the form.​

What is a form?
Do you mean UserForm?

And nothing normally happens automatically when using Excel.
And what names?

Yes its UserForm.

Consider we have invoices hard case and employee's take a invoice and make the order process. So they enter the invoice number they take and should enter the name in UerForm. And the entered name should be places against the Invoice number (Dump) in name column.

 

[My Aswer Is This]

OK.

I always need specific details.

1.I assume you have a button on a Userform and when you press this button the script will run

And you must have a Textbox on the Userform where the user enters his name

And you must have a Textbox on the Userform where the user enters the invoice number.

Or better yet the user would select the invoice number from a list of invoice numbers in a Combobox or listbox

So the script would be sort of like this:

Look down column A for the invoice number selected in Combobox1 or Listbox1 and enter the name entered in Textbox1 Into same row column B



Now I need to know the name of the Textbox where the user enters his name
And I need the name of the Textbox or Combobox or listbox where he selects or enters the invoice number.

​

We could load all the invoice numbers into a Combobox so you choose from the combobox so there are no mistakes

We would load the Combobox like this:

Combobox1.List= Range("A1:A400").value

Or something like that if you wanted to do things like that.
Please provide specific details like this.