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

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
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
325
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
177
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
215
ngochien251088
N
M
  • Question Question
Moving cells on to another worksheet
Replies
1
Views
242
Marvo
M
J
  • Question Question
Issues copying data to another sheet
Replies
4
Views
433
jynxy
J

Forum statistics

Threads
1,224,823
Messages
6,181,176
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