I am adding adding screenshot herewith.Wherever Invoice numbers are blank there take the challan number number and date to instead of Invoice number and date. I would like to have monthly item wise sale for each party. Hoping it is clearYou have given us very little to go on, other than a file which shows your data, but not what you want.
Also a lot of members will not, or cannot, access share sites for security reasons.
I would suggest that you explain exactly what you want, along with posting some sample data to the post.
There are some add-ins available here https://www.mrexcel.com/forum/about-board/508133-attachments.html that will enable you to post dat to the post.
|PARTY NAME & ADDRESS||PARTY NAME||ADDRESS||ITEM NAME||QTY||TYPE|
|2||5622218525||11/05/19||Honeywell -||Honeywell||BRAKE CAME / LEVER SET FRONT||15||PURCHASE|
|3||5622218535||18/05/19||Bush -||Bush||BRAKE CAME / LEVER SET REAR||40||PURCHASE|
|4||5622218585||22/05/19||Honeywell -||Honeywell||BRAKE PADEL||50||PURCHASE|
|5||5622218523||17/11/18||Rodger -||Rodger||BRAKE ROD COMPLETE||200||PURCHASE|
|6||5622251667||27/02/19||Sansui -||Sansui||BRAKE YOKE||100||PURCHASE|
|7||5622938243||11/02/19||K.K Trading -||K.K Trading||CHAIN SPROCKET SET||13||PURCHASE|
|8||5622938262||01/05/19||Sun and Sand -||Sun and Sand||BRAKE CAME / LEVER SET REAR||37||SALE|
|9||15/05/19||CH.1708||Sun and Sand - South KF||Sun and Sand||South KF||BRAKE CAME / LEVER SET REAR||2||SCHEME|
|10||17/05/19||CH.1709||Sun and Sand - West cost||Sun and Sand||West cost||BRAKE CAME / LEVER SET REAR||55||SALE|
|11||TAB/1819/25||21/06/19||Maxwell - Down town||Maxwell||Down town||BRAKE CAME / LEVER SET REAR||20||SALE|
|12||TAB/1819/28||22/06/19||CH.1749||Luminar - Market Place||Luminar||Market Place||BRAKE CAME / LEVER SET REAR||20||SALE|
|13||TAB/1819/30||25/06/19||CH.1747||Jumbo - Market Place||Jumbo||Market Place||BRAKE ROD COMPLETE||20||SALE|
|14||TAB/1819/29||26/06/19||CH.1905||Jumbo - Beach Road||Jumbo||Beach Road||BRAKE ROD COMPLETE||8||SCHEME|
|15||TAB/1819/45||27/06/19||Sun and Sand - West cost||Sun and Sand||West cost||BRAKE ROD COMPLETE||15||SALE|
|16||TAB/1819/47||28/06/19||K.K Trading - Market Place||K.K Trading||Market Place||BRAKE ROD COMPLETE||3||SALE|
|5||5622218525||11/05/19||BRAKE CAME / LEVER SET FRONT||15|
|10||Customer: Sun and Sand - West cost||Inward|
|12||CH.1709||17/05/19||BRAKE CAME / LEVER SET REAR||55|
|14||BRAKE ROD COMPLETE||15|
Sir with respect as you are a MVP at this site is it fair. Sir where is the same question. Is that same exact question which I asked in this site? And did I get the correct answer? I have posted my question here in this site 3 days before and since I did not get any answer and even any of the members did not understand my question but you find that is cross posting and I got the right answer. I am asking for help and you are talking about rules. Sir did someone wasting his time for asking question which is answered? Did you check how many hours before I was posted my question there? Since it is not the same post I did not give any link or clarification to here. You are not bothering about my time for just keep waiting for an answer from here. You are only bothering about rules.Cross posted https://chandoo.org/forum/threads/sales-summary-report.42026/
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.