Itemize Report with PRINT

TWINKLEMARVEL

Board Regular
Joined
Sep 24, 2008
Messages
101
Can somebody help in getting a code for the below:

Workbook "Inventory.xls"

sheet "Lookuplists " :

Range A - Employee
Range B - Client
Range C - Job
Range D - Rate

Sheet "Data" :

Range A - Employee
Range B - Client
Range C - Job
Range D - Date
Range E - Qty

cmdprint ------ Print

There are two user forms.
1st user form contains the following :

Userform .... frmremunerationreport

cboemployee

txtdate1
txtdate2

cmdgenerate


Based on the data form sheet "Data", and Sheet "LookupLists" I would like to get the total quantity of job done and Amount for each Job by selecting each employee, by providing FROM and TO date in " frmremunerationreport".

Upon clicking "cmdgenerate" , User form 2 which is "frmremunerationslip", should pop up, should have itemize report. i.e, for a specific employee the job done for CLIENT with QTY and AMOUNT should appear in the concern text box which should be printable.

USer Form 2 "frmremunerationslip" has got the following details


txtemployee

txtdate1 FROM date
txtdate2 TO date

txtclient1
txtclient2
txtclient3

txtjob1
txtjob2
txtjob3

txtqty1
txtqty2
txtqty3
txtqty4 ---- Total Qty ( Convert Quantity into Dozen and Display)

txtamount1
txtamount2
txtamount3
txtamount4 ---- Total Amount


Thanks
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,123,481
Messages
5,601,918
Members
414,482
Latest member
morkar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top