Macro Creation
 

I have problem(s) I could use some help with. Youll see in the attached
file, In the worksheet 'Make Invoice' I have a box for someone to type
in a Customer ID #. I have it setup to fill in the address, name, etc.
with the customer matching that ID# from the workbook 'Customers'. In
the same worksheet 'Make Invoice' I would like when that customer ID is
typed in, for it to match the customer ID# to any line with the same
customer ID# on the worksheet 'Job History' that has a 'n' in the
column titled "Paid?". When that column has an 'n' I would like it to
fill out on line 18 on worksheet 'Make Invoice' the appropriate Item
date and Price, and create a new line for each additional item.
Also youll see a "Send to Invoice History" button at the top of
worksheet 'Make Invoice'. I would like that to post the appropriate
data into worksheet "Invoice History" and after posting, clear "H9"
cell on worksheet 'Make Invoice'.


+-------------------------------------------------------------------+
|Filename: sample-post.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4165 |
+-------------------------------------------------------------------+

--
cbrd
------------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...o&userid=30009
View this thread: http://www.excelforum.com/showthread...hreadid=497009