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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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
217
shg
shg
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
199
ngochien251088
N
M
  • Question Question
Moving cells on to another worksheet
Replies
1
Views
240
Marvo
M
J
  • Question Question
Issues copying data to another sheet
Replies
4
Views
427
jynxy
J
M
  • Question Question
Copy values from row to another sheet matched to todays date
Replies
1
Views
448
Herakles
H

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

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