How do I Duplicate Sheets, so whatever I type on sheet 1 appears on sheet 2 and 3?

F

fatstickman

New Member
Joined
Feb 1, 2022
Messages
12
Office Version
  1. 365
Platform
  1. Windows
Help order summary.xlsm
ABCDEFGH
1 ORDER SUMMARY
2
3Date01/02/2022Customer Acc
4Contact nameOrder No
5Telephone NoName
6AddressPurchase Order
7Email
8NameSmithDeptPurchasing
9PRODUCTBRANDCODECOLOURSIZEQTYPRICE £
10Mens Long Sleeve Shirtkustom kitkk351white175£17.51
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
25      
26DECORATION
27EMBROIDERY COLOUREMBROIDERYLEFT CHESTRIGHT CHESTREARLEFT LEGQTYPRICE EACH £
28White/orange/silverPolosYesWeb10£4.00
29
30
31
32
33
34
35
36
37VINYL COLOURVINYL PRINTLEFT CHESTRIGHT CHESTFRONT CHESTREARQTYPRICE £
38
39
40
41
42
43
44
45
46
47
48
49SUB-TOTAL£127.55
50VAT RATE20%
51VAT£25.51
52TOTAL£153.06
53PAYMENT OPTIONACCOUNTCARDCASHBACSPRO FORMAOTHER
54Payment MethodYES
55 BANK DETAILS SORT CODE 20 26 34 ACOUNT NO 43240304
56 FATSTICKMAN LIMITED . UNIT 1B GILRAY ROAD . DISS . NORFOLK . IP22 4EU . 01379 658666
Sheet 1
Cell Formulas
RangeFormula
B3B3=TODAY()
C10C10=IFERROR(VLOOKUP(A10,I10:P27,3,FALSE),"")
D10D10=IFERROR(VLOOKUP(A10,I10:P27,4,FALSE),"")
E10E10=IFERROR(VLOOKUP(A10,I10:P27,5,FALSE),"")
F10F10=IFERROR(VLOOKUP(A10,I10:P27,6,FALSE),"")
H10H10=IFERROR(VLOOKUP(A10,I10:P27,8,FALSE),"")
C11C11=IFERROR(VLOOKUP(A11,I10:P27,3,FALSE),"")
D11D11=IFERROR(VLOOKUP(A11,I10:P27,4,FALSE),"")
E11E11=IFERROR(VLOOKUP(A11,I10:P27,5,FALSE),"")
F11F11=IFERROR(VLOOKUP(A11,I10:P27,6,FALSE),"")
G11G11=IFERROR(VLOOKUP(A11,I10:P27,7,FALSE),"")
H11H11=IFERROR(VLOOKUP(A11,I10:P27,8,FALSE),"")
C12C12=IFERROR(VLOOKUP(A12,I10:P27,3,FALSE),"")
D12D12=IFERROR(VLOOKUP(A12,I10:P27,4,FALSE),"")
E12E12=IFERROR(VLOOKUP(A12,I10:P27,5,FALSE),"")
F12F12=IFERROR(VLOOKUP(A12,I10:P27,6,FALSE),"")
G12G12=IFERROR(VLOOKUP(A12,I10:P27,7,FALSE),"")
H12H12=IFERROR(VLOOKUP(A12,I10:P27,8,FALSE),"")
C13C13=IFERROR(VLOOKUP(A13,I10:P28,3,FALSE),"")
D13D13=IFERROR(VLOOKUP(A13,I10:P28,4,FALSE),"")
E13E13=IFERROR(VLOOKUP(A13,I10:P28,5,FALSE),"")
F13F13=IFERROR(VLOOKUP(A13,I10:P28,6,FALSE),"")
G13G13=IFERROR(VLOOKUP(A13,I10:P28,7,FALSE),"")
H13H13=IFERROR(VLOOKUP(A13,I10:P28,8,FALSE),"")
C14C14=IFERROR(VLOOKUP(A14,I10:P29,3,FALSE),"")
D14D14=IFERROR(VLOOKUP(A14,I10:P29,4,FALSE),"")
E14E14=IFERROR(VLOOKUP(A14,I10:P29,5,FALSE),"")
F14F14=IFERROR(VLOOKUP(A14,I10:P29,6,FALSE),"")
G14G14=IFERROR(VLOOKUP(A14,I10:P29,7,FALSE),"")
H14H14=IFERROR(VLOOKUP(A14,I10:P29,8,FALSE),"")
C15C15=IFERROR(VLOOKUP(A15,I10:P30,3,FALSE),"")
D15D15=IFERROR(VLOOKUP(A15,I10:P30,4,FALSE),"")
E15E15=IFERROR(VLOOKUP(A15,I10:P30,5,FALSE),"")
F15F15=IFERROR(VLOOKUP(A15,I10:P30,6,FALSE),"")
G15G15=IFERROR(VLOOKUP(A15,I10:P30,7,FALSE),"")
H15H15=IFERROR(VLOOKUP(A15,I10:P30,8,FALSE),"")
C16C16=IFERROR(VLOOKUP(A16,I10:P31,3,FALSE),"")
D16D16=IFERROR(VLOOKUP(A16,I10:P31,4,FALSE),"")
E16E16=IFERROR(VLOOKUP(A16,I10:P31,5,FALSE),"")
F16F16=IFERROR(VLOOKUP(A16,I10:P31,6,FALSE),"")
G16G16=IFERROR(VLOOKUP(A16,I10:P31,7,FALSE),"")
H16H16=IFERROR(VLOOKUP(A16,I10:P31,8,FALSE),"")
C17C17=IFERROR(VLOOKUP(A17,I10:P32,3,FALSE),"")
D17D17=IFERROR(VLOOKUP(A17,I10:P32,4,FALSE),"")
E17E17=IFERROR(VLOOKUP(A17,I10:P32,5,FALSE),"")
F17F17=IFERROR(VLOOKUP(A17,I10:P32,6,FALSE),"")
G17G17=IFERROR(VLOOKUP(A17,I10:P32,7,FALSE),"")
H17H17=IFERROR(VLOOKUP(A17,I10:P32,8,FALSE),"")
C18C18=IFERROR(VLOOKUP(A18,I10:P33,3,FALSE),"")
D18D18=IFERROR(VLOOKUP(A18,I10:P33,4,FALSE),"")
E18E18=IFERROR(VLOOKUP(A18,I10:P33,5,FALSE),"")
F18F18=IFERROR(VLOOKUP(A18,I10:P33,6,FALSE),"")
G18G18=IFERROR(VLOOKUP(A18,I10:P33,7,FALSE),"")
H18H18=IFERROR(VLOOKUP(A18,I10:P33,8,FALSE),"")
C19C19=IFERROR(VLOOKUP(A19,I10:P34,3,FALSE),"")
D19D19=IFERROR(VLOOKUP(A19,I10:P34,4,FALSE),"")
E19E19=IFERROR(VLOOKUP(A19,I10:P34,5,FALSE),"")
F19F19=IFERROR(VLOOKUP(A19,I10:P34,6,FALSE),"")
G19G19=IFERROR(VLOOKUP(A19,I10:P34,7,FALSE),"")
H19H19=IFERROR(VLOOKUP(A19,I10:P34,8,FALSE),"")
C20C20=IFERROR(VLOOKUP(A20,I10:P35,3,FALSE),"")
D20D20=IFERROR(VLOOKUP(A20,I10:P35,4,FALSE),"")
E20E20=IFERROR(VLOOKUP(A20,I10:P35,5,FALSE),"")
F20F20=IFERROR(VLOOKUP(A20,I10:P35,6,FALSE),"")
G20G20=IFERROR(VLOOKUP(A20,I10:P35,7,FALSE),"")
H20H20=IFERROR(VLOOKUP(A20,I10:P35,8,FALSE),"")
C21C21=IFERROR(VLOOKUP(A21,I10:P36,3,FALSE),"")
D21D21=IFERROR(VLOOKUP(A21,I10:P36,4,FALSE),"")
E21E21=IFERROR(VLOOKUP(A21,I10:P36,5,FALSE),"")
F21F21=IFERROR(VLOOKUP(A21,I10:P36,6,FALSE),"")
G21G21=IFERROR(VLOOKUP(A21,I10:P36,7,FALSE),"")
H21H21=IFERROR(VLOOKUP(A21,I10:P36,8,FALSE),"")
C22C22=IFERROR(VLOOKUP(A22,I10:P37,3,FALSE),"")
D22D22=IFERROR(VLOOKUP(A22,I10:P37,4,FALSE),"")
E22E22=IFERROR(VLOOKUP(A22,I10:P37,5,FALSE),"")
F22F22=IFERROR(VLOOKUP(A22,I10:P37,6,FALSE),"")
G22G22=IFERROR(VLOOKUP(A22,I10:P37,7,FALSE),"")
H22H22=IFERROR(VLOOKUP(A22,I10:P37,8,FALSE),"")
C23C23=IFERROR(VLOOKUP(A23,I10:P38,3,FALSE),"")
D23D23=IFERROR(VLOOKUP(A23,I10:P38,4,FALSE),"")
E23E23=IFERROR(VLOOKUP(A23,I10:P38,5,FALSE),"")
F23F23=IFERROR(VLOOKUP(A23,I10:P38,6,FALSE),"")
G23G23=IFERROR(VLOOKUP(A23,I10:P38,7,FALSE),"")
H23H23=IFERROR(VLOOKUP(A23,I10:P38,8,FALSE),"")
C24C24=IFERROR(VLOOKUP(A24,I10:P39,3,FALSE),"")
D24D24=IFERROR(VLOOKUP(A24,I24:P39,4,FALSE),"")
E24E24=IFERROR(VLOOKUP(A24,I10:P39,5,FALSE),"")
F24F24=IFERROR(VLOOKUP(A24,I10:P39,6,FALSE),"")
G24G24=IFERROR(VLOOKUP(A24,I10:P39,7,FALSE),"")
H24H24=IFERROR(VLOOKUP(A24,I10:P39,8,FALSE),"")
C25C25=IFERROR(VLOOKUP(A25,I10:P40,3,FALSE),"")
D25D25=IFERROR(VLOOKUP(A25,I10:P40,4,FALSE),"")
E25E25=IFERROR(VLOOKUP(A25,I10:P40,5,FALSE),"")
F25F25=IFERROR(VLOOKUP(A25,I10:P40,6,FALSE),"")
G25G25=IFERROR(VLOOKUP(A25,I10:P40,7,FALSE),"")
H25H25=IFERROR(VLOOKUP(A25,II0:P40,8,FALSE),"")
H49H49=SUMPRODUCT(G10:G26,H10:H26)+SUMPRODUCT(G28:G36,H28:H36)+SUMPRODUCT(G38:G47,H38:H47)
H51H51=SUM(H49*H50)
H52H52=SUM(H49+H51)
Cells with Data Validation
CellAllowCriteria
A10:B25List=$I$10:$I$27
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Sort by date Sort by votes
Help order summary.xlsm
ABCDEFGH
1 ORDER SUMMARY
2
3Date01/02/2022Customer Acc
4Contact nameOrder No
5Telephone NoName
6AddressPurchase Order
7Email
8NameSmithDeptPurchasing
9PRODUCTBRANDCODECOLOURSIZEQTYPRICE £
10Mens Long Sleeve Shirtkustom kitkk351white175£17.51
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
25      
26DECORATION
27EMBROIDERY COLOUREMBROIDERYLEFT CHESTRIGHT CHESTREARLEFT LEGQTYPRICE EACH £
28White/orange/silverPolosYesWeb10£4.00
29
30
31
32
33
34
35
36
37VINYL COLOURVINYL PRINTLEFT CHESTRIGHT CHESTFRONT CHESTREARQTYPRICE £
38
39
40
41
42
43
44
45
46
47
48
49SUB-TOTAL£127.55
50VAT RATE20%
51VAT£25.51
52TOTAL£153.06
53PAYMENT OPTIONACCOUNTCARDCASHBACSPRO FORMAOTHER
54Payment MethodYES
55 BANK DETAILS SORT CODE 20 26 34 ACOUNT NO 43240304
56 FATSTICKMAN LIMITED . UNIT 1B GILRAY ROAD . DISS . NORFOLK . IP22 4EU . 01379 658666
Sheet 1
Cell Formulas
RangeFormula
B3B3=TODAY()
C10C10=IFERROR(VLOOKUP(A10,I10:P27,3,FALSE),"")
D10D10=IFERROR(VLOOKUP(A10,I10:P27,4,FALSE),"")
E10E10=IFERROR(VLOOKUP(A10,I10:P27,5,FALSE),"")
F10F10=IFERROR(VLOOKUP(A10,I10:P27,6,FALSE),"")
H10H10=IFERROR(VLOOKUP(A10,I10:P27,8,FALSE),"")
C11C11=IFERROR(VLOOKUP(A11,I10:P27,3,FALSE),"")
D11D11=IFERROR(VLOOKUP(A11,I10:P27,4,FALSE),"")
E11E11=IFERROR(VLOOKUP(A11,I10:P27,5,FALSE),"")
F11F11=IFERROR(VLOOKUP(A11,I10:P27,6,FALSE),"")
G11G11=IFERROR(VLOOKUP(A11,I10:P27,7,FALSE),"")
H11H11=IFERROR(VLOOKUP(A11,I10:P27,8,FALSE),"")
C12C12=IFERROR(VLOOKUP(A12,I10:P27,3,FALSE),"")
D12D12=IFERROR(VLOOKUP(A12,I10:P27,4,FALSE),"")
E12E12=IFERROR(VLOOKUP(A12,I10:P27,5,FALSE),"")
F12F12=IFERROR(VLOOKUP(A12,I10:P27,6,FALSE),"")
G12G12=IFERROR(VLOOKUP(A12,I10:P27,7,FALSE),"")
H12H12=IFERROR(VLOOKUP(A12,I10:P27,8,FALSE),"")
C13C13=IFERROR(VLOOKUP(A13,I10:P28,3,FALSE),"")
D13D13=IFERROR(VLOOKUP(A13,I10:P28,4,FALSE),"")
E13E13=IFERROR(VLOOKUP(A13,I10:P28,5,FALSE),"")
F13F13=IFERROR(VLOOKUP(A13,I10:P28,6,FALSE),"")
G13G13=IFERROR(VLOOKUP(A13,I10:P28,7,FALSE),"")
H13H13=IFERROR(VLOOKUP(A13,I10:P28,8,FALSE),"")
C14C14=IFERROR(VLOOKUP(A14,I10:P29,3,FALSE),"")
D14D14=IFERROR(VLOOKUP(A14,I10:P29,4,FALSE),"")
E14E14=IFERROR(VLOOKUP(A14,I10:P29,5,FALSE),"")
F14F14=IFERROR(VLOOKUP(A14,I10:P29,6,FALSE),"")
G14G14=IFERROR(VLOOKUP(A14,I10:P29,7,FALSE),"")
H14H14=IFERROR(VLOOKUP(A14,I10:P29,8,FALSE),"")
C15C15=IFERROR(VLOOKUP(A15,I10:P30,3,FALSE),"")
D15D15=IFERROR(VLOOKUP(A15,I10:P30,4,FALSE),"")
E15E15=IFERROR(VLOOKUP(A15,I10:P30,5,FALSE),"")
F15F15=IFERROR(VLOOKUP(A15,I10:P30,6,FALSE),"")
G15G15=IFERROR(VLOOKUP(A15,I10:P30,7,FALSE),"")
H15H15=IFERROR(VLOOKUP(A15,I10:P30,8,FALSE),"")
C16C16=IFERROR(VLOOKUP(A16,I10:P31,3,FALSE),"")
D16D16=IFERROR(VLOOKUP(A16,I10:P31,4,FALSE),"")
E16E16=IFERROR(VLOOKUP(A16,I10:P31,5,FALSE),"")
F16F16=IFERROR(VLOOKUP(A16,I10:P31,6,FALSE),"")
G16G16=IFERROR(VLOOKUP(A16,I10:P31,7,FALSE),"")
H16H16=IFERROR(VLOOKUP(A16,I10:P31,8,FALSE),"")
C17C17=IFERROR(VLOOKUP(A17,I10:P32,3,FALSE),"")
D17D17=IFERROR(VLOOKUP(A17,I10:P32,4,FALSE),"")
E17E17=IFERROR(VLOOKUP(A17,I10:P32,5,FALSE),"")
F17F17=IFERROR(VLOOKUP(A17,I10:P32,6,FALSE),"")
G17G17=IFERROR(VLOOKUP(A17,I10:P32,7,FALSE),"")
H17H17=IFERROR(VLOOKUP(A17,I10:P32,8,FALSE),"")
C18C18=IFERROR(VLOOKUP(A18,I10:P33,3,FALSE),"")
D18D18=IFERROR(VLOOKUP(A18,I10:P33,4,FALSE),"")
E18E18=IFERROR(VLOOKUP(A18,I10:P33,5,FALSE),"")
F18F18=IFERROR(VLOOKUP(A18,I10:P33,6,FALSE),"")
G18G18=IFERROR(VLOOKUP(A18,I10:P33,7,FALSE),"")
H18H18=IFERROR(VLOOKUP(A18,I10:P33,8,FALSE),"")
C19C19=IFERROR(VLOOKUP(A19,I10:P34,3,FALSE),"")
D19D19=IFERROR(VLOOKUP(A19,I10:P34,4,FALSE),"")
E19E19=IFERROR(VLOOKUP(A19,I10:P34,5,FALSE),"")
F19F19=IFERROR(VLOOKUP(A19,I10:P34,6,FALSE),"")
G19G19=IFERROR(VLOOKUP(A19,I10:P34,7,FALSE),"")
H19H19=IFERROR(VLOOKUP(A19,I10:P34,8,FALSE),"")
C20C20=IFERROR(VLOOKUP(A20,I10:P35,3,FALSE),"")
D20D20=IFERROR(VLOOKUP(A20,I10:P35,4,FALSE),"")
E20E20=IFERROR(VLOOKUP(A20,I10:P35,5,FALSE),"")
F20F20=IFERROR(VLOOKUP(A20,I10:P35,6,FALSE),"")
G20G20=IFERROR(VLOOKUP(A20,I10:P35,7,FALSE),"")
H20H20=IFERROR(VLOOKUP(A20,I10:P35,8,FALSE),"")
C21C21=IFERROR(VLOOKUP(A21,I10:P36,3,FALSE),"")
D21D21=IFERROR(VLOOKUP(A21,I10:P36,4,FALSE),"")
E21E21=IFERROR(VLOOKUP(A21,I10:P36,5,FALSE),"")
F21F21=IFERROR(VLOOKUP(A21,I10:P36,6,FALSE),"")
G21G21=IFERROR(VLOOKUP(A21,I10:P36,7,FALSE),"")
H21H21=IFERROR(VLOOKUP(A21,I10:P36,8,FALSE),"")
C22C22=IFERROR(VLOOKUP(A22,I10:P37,3,FALSE),"")
D22D22=IFERROR(VLOOKUP(A22,I10:P37,4,FALSE),"")
E22E22=IFERROR(VLOOKUP(A22,I10:P37,5,FALSE),"")
F22F22=IFERROR(VLOOKUP(A22,I10:P37,6,FALSE),"")
G22G22=IFERROR(VLOOKUP(A22,I10:P37,7,FALSE),"")
H22H22=IFERROR(VLOOKUP(A22,I10:P37,8,FALSE),"")
C23C23=IFERROR(VLOOKUP(A23,I10:P38,3,FALSE),"")
D23D23=IFERROR(VLOOKUP(A23,I10:P38,4,FALSE),"")
E23E23=IFERROR(VLOOKUP(A23,I10:P38,5,FALSE),"")
F23F23=IFERROR(VLOOKUP(A23,I10:P38,6,FALSE),"")
G23G23=IFERROR(VLOOKUP(A23,I10:P38,7,FALSE),"")
H23H23=IFERROR(VLOOKUP(A23,I10:P38,8,FALSE),"")
C24C24=IFERROR(VLOOKUP(A24,I10:P39,3,FALSE),"")
D24D24=IFERROR(VLOOKUP(A24,I24:P39,4,FALSE),"")
E24E24=IFERROR(VLOOKUP(A24,I10:P39,5,FALSE),"")
F24F24=IFERROR(VLOOKUP(A24,I10:P39,6,FALSE),"")
G24G24=IFERROR(VLOOKUP(A24,I10:P39,7,FALSE),"")
H24H24=IFERROR(VLOOKUP(A24,I10:P39,8,FALSE),"")
C25C25=IFERROR(VLOOKUP(A25,I10:P40,3,FALSE),"")
D25D25=IFERROR(VLOOKUP(A25,I10:P40,4,FALSE),"")
E25E25=IFERROR(VLOOKUP(A25,I10:P40,5,FALSE),"")
F25F25=IFERROR(VLOOKUP(A25,I10:P40,6,FALSE),"")
G25G25=IFERROR(VLOOKUP(A25,I10:P40,7,FALSE),"")
H25H25=IFERROR(VLOOKUP(A25,II0:P40,8,FALSE),"")
H49H49=SUMPRODUCT(G10:G26,H10:H26)+SUMPRODUCT(G28:G36,H28:H36)+SUMPRODUCT(G38:G47,H38:H47)
H51H51=SUM(H49*H50)
H52H52=SUM(H49+H51)
Cells with Data Validation
CellAllowCriteria
A10:B25List=$I$10:$I$27
 
Upvote 0
You must log in or register to reply here.

Similar threads

gtd526
  • Question
search and answer only ODD rows
Replies
6
Views
142
gtd526
gtd526
M
  • Question
Running unique count of occurrence on table based on date
Replies
0
Views
158
Minx_Minxy
M
J
  • Solved
trending value projections without counting sundays
Replies
2
Views
123
KRice
K
SaraWitch
  • Solved
VLOOKUP formula with multiple IF statements
Replies
2
Views
456
SaraWitch
SaraWitch
gtd526
  • Solved
Conditional Formatting matching Top 3 values in 2 columns
Replies
4
Views
507
Fluff
Fluff

Forum statistics

Threads
1,214,884
Messages
6,122,082
Members
449,064
Latest member
MattDRT

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