Sales Report

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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
61
ShawnSPS
S
S
  • Question Question
IF Command? Help with sales spreadsheet Please
Replies
6
Views
76
etaf
etaf
D
  • Question Question
=IF(And formula
Replies
2
Views
118
davids4500
D
M
  • Question Question
Create Report across sheets based on two dates as in my attachment
Replies
0
Views
144
Maklil
M
K
  • Solved
I need procedure to populate data in listbox based on another listbox
Replies
2
Views
83
KalilMe
K

Forum statistics

Threads
1,224,823
Messages
6,181,180
Members
453,021
Latest member
Justyna P

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