Insert data into a seperate worksheet

[Pat]

Hello,

I'm very new to VB and was looking for some direction on the
following:

I have a workbook with two sheets, Menu and Manifest. In the menu
sheet I want users to enter a Customer ID(txtCUSTID) and Invoice
#(txtInvnum) into two different text boxes respectively. After this
information has been entered, users will click a button(Update
Manifest)which updates the Manifest sheet. The manifest sheet will
contain two columns, CUSTID and INVNUMBER. When the Update Manifest
button is clicked on the menu sheet, the program should look for
matching CUSTID's in the CUSTID column and add the Invoice Number from
txtInvNum to the Invoice column.

So, essentially I'm looking for help with the code for my command
button to do the above, which is append a column when a customer match
is found.

I have no idea where to start with the code. Any help would be greatly
appreciated.

Thanks in advance for your help.

Pat

 

[Anders S]

Pat,

I don't quite understand what you want here, but I'm sure it's not very complicated.

On one hand you say to "add the Invoice Number from txtInvNum to the Invoice column". On the other hand you say to "append a column".

Do you mean to enter the invoice numbers in horizontally in separate columns for each customer, or what?

Post back with a small example of how you want the layout of the manifest sheet. An explanation of how it will be used is also helpful.

Best regards,
Anders Silvén

 

[Pat]

All I want is for this information to be stored in two columns in a
seperate work sheet. The information would be entered into a second
worksheet. On the second worksheet there would be a fixed column with
customer ID's. This column does not change when the information is
inputed in the first sheet. However, the Invoice column does change in
two ways: 1. When a user adds an invoice#, that invoice number is
added to the invoice# column; to its corresponding customer ID. 2. the
other way the column changes is if the user decides to clear the
manifest, which only clears the invoice # column. This is what it
should look like:


CUSTID INV#
Cust1 1234
Cust2 9876
Cust3 9874
5678
Cust4 1245
Cust5 Empty

There can be more than one invoice # for a customer in the invoice
column. In this case, multiple invoice numbers should appear in one
cell. Also, a customer does not have to have an invoice #.

The manifest is used by a shipping courier to verify parcels using the
invoice number. If a customer does not have an invoice# beside their
ID, then they have no shippment for the day.

Also, what I meant by append is that invoice numbers are not
overwritten by other invoice numbers, they are only cleared at the end
of the day.


Thanks again. I hope this helps.