Show Sale of Town A or etc from 1 sheet to another sheet

S

smyle

New Member
Joined
Nov 24, 2017
Messages
1
Dear Experts, i have 2 sheets, in 1 sheet we have different town sale and in 2nd sheet how can i put these sale into their column. please help me in this.

Sheet 1

[TABLE="width: 877"]
<colgroup><col><col><col><col span="7"><col><col span="3"></colgroup><tbody>[TR]
[TD]SAPCODE[/TD]
[TD]Code[/TD]
[TD]SKUName[/TD]
[TD]ID[/TD]
[TD]SKUID[/TD]
[TD]Opening Stock[/TD]
[TD]Receipt[/TD]
[TD]Purchase Return[/TD]
[TD]MTD Issued[/TD]
[TD]SReturn[/TD]
[TD]CStock[/TD]
[TD]A[/TD]
[TD]K[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD][/TD]
[TD]Pencil[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD="align: right"]456[/TD]
[TD][/TD]
[TD]Paper[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD="align: right"]789[/TD]
[TD][/TD]
[TD]Cup[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD="align: right"]1122[/TD]
[TD][/TD]
[TD]Scale[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD="align: right"]3344[/TD]
[TD][/TD]
[TD]Sharpner[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD="align: right"]5566[/TD]
[TD][/TD]
[TD]Cutter[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD="align: right"]7788[/TD]
[TD][/TD]
[TD]Gum Stick[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]10[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2

[TABLE="width: 1372"]
<colgroup><col><col><col><col><col><col span="26"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD] Opening Stock [/TD]
[TD] Received From Company [/TD]
[TD] Recevied From Others [/TD]
[TD="colspan: 12"] Town List [/TD]
[TD="colspan: 4"] Town List [/TD]
[TD="colspan: 4"] Town List [/TD]
[TD="colspan: 6"] Town List [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sku Code[/TD]
[TD]SKU[/TD]
[TD] Cases [/TD]
[TD] Cases [/TD]
[TD] Cases [/TD]
[TD] A [/TD]
[TD] B [/TD]
[TD] C [/TD]
[TD] D [/TD]
[TD] E [/TD]
[TD] F [/TD]
[TD] G [/TD]
[TD] H [/TD]
[TD] I [/TD]
[TD] J [/TD]
[TD] K [/TD]
[TD] L [/TD]
[TD] M [/TD]
[TD] N [/TD]
[TD] O [/TD]
[TD] P [/TD]
[TD] Q [/TD]
[TD] R [/TD]
[TD] S [/TD]
[TD] T [/TD]
[TD] U [/TD]
[TD] V [/TD]
[TD] W [/TD]
[TD] X [/TD]
[TD] Y [/TD]
[TD] Z [/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]Pencil[/TD]
[TD] 10[/TD]
[TD] 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]Paper[/TD]
[TD] 10[/TD]
[TD] 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]789[/TD]
[TD]Cup[/TD]
[TD] 10[/TD]
[TD] 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1122[/TD]
[TD]Scale[/TD]
[TD] 10[/TD]
[TD] 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3344[/TD]
[TD]Sharpner[/TD]
[TD] 10[/TD]
[TD] 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5566[/TD]
[TD]Cutter[/TD]
[TD] 10[/TD]
[TD] 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7788[/TD]
[TD]Gum Stick[/TD]
[TD] 10[/TD]
[TD] 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
Hi,
copy this into sheet 2 under town A and copy down and across.
Code: 
=IFERROR(SUMPRODUCT(--((Sheet1!$A$2:$A$8=Sheet2!$A3)*(Sheet1!$C$2:$C$8=Sheet2!$B3)*(Sheet1!$L$1:$N$1=Sheet2!F$2)),Sheet1!$L$2:$N$8),0)
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Creating a random sequence of items from a weighted list with no duplicates
Replies
6
Views
407
shg
shg
D
  • Question Question
How to Copy rows from one sheet to another based on the criteria in the second sheet
Replies
9
Views
257
dsubash
D
N
  • Solved
VBA auto fill in information from the list in one sheet to another sheet and save as the excel file.
Replies
5
Views
242
ngochien251088
N
M
  • Question Question
Moving cells on to another worksheet
Replies
1
Views
251
Marvo
M
J
  • Question Question
Issues copying data to another sheet
Replies
4
Views
458
jynxy
J

Forum statistics

Threads
1,225,759
Messages
6,186,863
Members
453,380
Latest member
ShaeJ73

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