LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Insert data into a seperate worksheet

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation against seperate worksheet Kcope8302 Excel Worksheet Functions 1 July 17th 09 02:19 PM
Reference web query data in seperate worksheet AmyLRuck Excel Worksheet Functions 1 October 4th 08 04:46 PM
Data in a seperate worksheet F.G. Excel Discussion (Misc queries) 2 January 14th 08 07:48 PM
Auto insert data to seperate sheets? greig2000_uk New Users to Excel 2 May 27th 06 01:10 PM
viewing seperate data within worksheet Gate Excel Worksheet Functions 1 March 8th 05 06:42 PM


All times are GMT +1. The time now is 06:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"