Sales Report

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
Here is the screen shot

may someone help me

This is data

In the report sheet Items are selected through the drop down list.

Sheet3[TABLE="class: html-maker-worksheet"]
<thead>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[/TR]
</thead><tbody>[TR]
[TH]1[/TH]
[TD]Date[/TD]
[TD]Invoice No[/TD]
[TD]Party Name[/TD]
[TD]Item Description[/TD]
[TD]Qty[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD="align: right"]01/04/18[/TD]
[TD]54845882231[/TD]
[TD]Bajaj Electrical[/TD]
[TD]Bajaj Majesty DX-4 Iron Box[/TD]
[TD="align: right"]15[/TD]
[TD]purchase[/TD]
[/TR]
[TR]
[TH]3[/TH]
[TD="align: right"]15/04/18[/TD]
[TD]JVM/1835/2018[/TD]
[TD]ARUN TRADERS[/TD]
[TD]Bajaj Majesty DX-4 Iron Box[/TD]
[TD="align: right"]2[/TD]
[TD]SALE[/TD]
[/TR]
[TR]
[TH]4[/TH]
[TD="align: right"]10/04/18[/TD]
[TD]3885646851[/TD]
[TD]Almonarod[/TD]
[TD] Almonarod 250 mm shutter Fan[/TD]
[TD="align: right"]12[/TD]
[TD]purchase[/TD]
[/TR]
[TR]
[TH]5[/TH]
[TD="align: right"]12/04/18[/TD]
[TD]JVM/1836/2018[/TD]
[TD]Sangam Electricals[/TD]
[TD] Almonarod 250 mm shutter Fan[/TD]
[TD="align: right"]8[/TD]
[TD]SALE[/TD]
[/TR]
[TR]
[TH]6[/TH]
[TD="align: right"]15/04/18[/TD]
[TD]Credit Note[/TD]
[TD]Sangam Electricals[/TD]
[TD] Almonarod 250 mm shutter Fan[/TD]
[TD="align: right"]2[/TD]
[TD]Sales Return[/TD]
[/TR]
[TR]
[TH]7[/TH]
[TD="align: right"]13/04/18[/TD]
[TD]Credit Note[/TD]
[TD]ARUN TRADERS[/TD]
[TD]Bajaj Majesty DX-4 Iron Box[/TD]
[TD="align: right"]1[/TD]
[TD]Sales Return[/TD]
[/TR]
[TR]
[TH]8[/TH]
[TD="align: right"]13/04/18[/TD]
[TD]JVM/1837/2018[/TD]
[TD]Gopal Marketing[/TD]
[TD]Bajaj Majesty DX-4 Iron Box[/TD]
[TD="align: right"]1[/TD]
[TD]Sale[/TD]
[/TR]
[TR]
[TH]9[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]10[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]11[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]12[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]13[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]14[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]15[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]16[/TH]
[TD][/TD]
[TD]Note[/TD]
[TD]Purchase = Inward[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]17[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]18[/TH]
[TD][/TD]
[TD][/TD]
[TD]Sales Return = Inward[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]19[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]20[/TH]
[TD][/TD]
[TD][/TD]
[TD]Sale = Outward[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]21[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]22[/TH]
[TD][/TD]
[TD][/TD]
[TD]Scheme = Outward[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]23[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]24[/TH]
[TD][/TD]
[TD][/TD]
[TD]Foc = Outward[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]25[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]26[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Excel 2007








Output may like this

Report[TABLE="class: html-maker-worksheet"]
<tbody>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[TH]J[/TH]
[/TR]
[TR]
[TH]1[/TH]
[TD="align: center"]Item[/TD]
[TD="align: center"] Almonarod 250 mm shutter Fan[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Drop down list here[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD]Opening Balance[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Balance[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]3[/TH]
[TD]Date[/TD]
[TD]Customer Name[/TD]
[TD="align: center"]Invoice No.[/TD]
[TD="align: center"]Inwards[/TD]
[TD="align: center"]Outwards[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]4[/TH]
[TD]10/04/18[/TD]
[TD]Almonarod[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]5[/TH]
[TD]12/04/18[/TD]
[TD]Sangam Electricals[/TD]
[TD]JVM/1836/2018[/TD]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]6[/TH]
[TD]15/04/18[/TD]
[TD]Sangam Electricals[/TD]
[TD]Credit Note[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]7[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]8[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]9[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]10[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]11[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]12[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]13[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]14[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]15[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Excel 2007



Master[TABLE="class: html-maker-worksheet"]
<tbody>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[/TR]
[TR]
[TH]1[/TH]
[TD="align: center"]Item Name[/TD]
[TD="align: center"]Stock
Opening Balance[/TD]
[TD][/TD]
[TD]Customer Name[/TD]
[TD]Address[/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD] Almonarod 150 mm Metal Fan Almonard[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Arun Traders[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]3[/TH]
[TD] Almonarod 150 mm shutter Fan Almonard[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Gopal Marketing[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]4[/TH]
[TD] Almonarod 250 mm shutter Fan[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Sangam Electricals[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]5[/TH]
[TD] Almonarod HD AIR 300 mm[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Bajaj Electrical[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]6[/TH]
[TD] Almonarod HD AIR 380 mm[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]VGuard[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]7[/TH]
[TD] Almonarod HD AIR 450 mm[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Almonarod[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]8[/TH]
[TD] Almonarod Pedestal Fan 450 mm Almonard[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Varun Traders[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]9[/TH]
[TD] Almonarod Pedestal Fan Mark II 80 watts Almonard[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]Sagar Electricals[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]10[/TH]
[TD] Almonarod Wall Fan Mark II Almonarod[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD]Bajaj Electrical[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Excel 2007
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Sales Planners - sync date with days and print in book form
Replies
0
Views
56
ShawnSPS
S
S
  • Question Question
IF Command? Help with sales spreadsheet Please
Replies
6
Views
71
etaf
etaf
D
  • Question Question
=IF(And formula
Replies
2
Views
93
davids4500
D
M
  • Question Question
Create Report across sheets based on two dates as in my attachment
Replies
0
Views
141
Maklil
M
A
  • Solved
Hide Column with multiple command buttons
2
Replies
10
Views
315
arisomar
A

Forum statistics

Threads
1,223,896
Messages
6,175,265
Members
452,627
Latest member
KitkatToby

Share this page

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
Back
Top