Billing Invoice

[rjbautista20]

Hi guys,

Would like to ask for your help again. my boss wants to create a billing template where source data will be downloaded from our database.

right now, we manually copy and paste the data which leads to human error. what we want to do is to have a macro to copy it based on acct number and document type number.

Example:

SourceData Contains the Following

Acct Number: 123345
Document Type: RV, RZ, RD,
Document Number: 5324234
Invoice Date: 3/23/2012
Received Date: 3/21/2012
Amount: 10000


Acct Number could be multiple row and we only want to reflect in the billing are the RV Type.

hope you can help me again.

Thanks.

[dilipandey]

Hi rjbautista20,

As your source is also appearing as an Excel worksheet, I would suggest you to use advance filter feature of Excel, which can be converted to a macro approach later. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>