tlchan
10-17-2010, 09:16 AM
Hi There,
I have a worksheet("Cust_stmt") as master statement for input of variable customer data from worksheet("custdata") using Vlookup function using VBA. Whenever range ("I9") changed the value.(customer's account No) will trigger the code to fill up the respective data for individual statement.
What I wish to achieve as to how should I print out each individual account statement via VBA instead of input manually one by one for account No in order to print the statement.
Any body can help ? :friends:
sample file attached
I have a worksheet("Cust_stmt") as master statement for input of variable customer data from worksheet("custdata") using Vlookup function using VBA. Whenever range ("I9") changed the value.(customer's account No) will trigger the code to fill up the respective data for individual statement.
What I wish to achieve as to how should I print out each individual account statement via VBA instead of input manually one by one for account No in order to print the statement.
Any body can help ? :friends:
sample file attached