µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ¼Ï¯Ã¤ÀªR+¶×¤J¨ä¥L¸ê®Æªí¸ê®Æ
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
¼Ï¯Ã¤ÀªR+¶×¤J¨ä¥L¸ê®Æªí¸ê®Æ
v03586
µoµu®ø®§
¥[¬°¦n¤Í
v03586
·í«eÂ÷½u
UID
22132
©«¤l
193
¥DÃD
29
ºëµØ
0
¿n¤À
222
ª÷¿ú
222
ÂI¦W
0
§@·~¨t²Î
Windows7
³nÅ骩¥»
OFFICE2013
¾\ŪÅv
20
¦b½u®É¶¡
250 ¤p®É
µù¥U®É¶¡
2015-9-18
³Ì«áµn¿ý
2023-4-29
¤¤¾Ç¥Í
©«¤l
193
¥DÃD
29
ºëµØ
0
¿n¤À
222
ÂI¦W
0
§@·~¨t²Î
Windows7
³nÅ骩¥»
OFFICE2013
¾\ŪÅv
20
µù¥U®É¶¡
2015-9-18
³Ì«áµn¿ý
2023-4-29
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2017-8-15 15:28
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
¼Ï¯Ã¤ÀªR+¶×¤J¨ä¥L¸ê®Æªí¸ê®Æ
¼Ï¯Ã¤ÀªR¥Î¿ý»sªº, ¥un¥Lªº°Ñ¦Ò¸ê®Æ¦³·s¼W¨S¦³³Q¿ý»s¶i¥hªº¸ê®Æ´N·|¸õ¥X¿ù»~
·Q½Ð±Ð¦U¦ì°ª¤â̦³¨S¦³¤ñ¸û¦nªº¤è¦¡¥i¥H§e²{¥XÃþ¦ü¤U¹Ïªºªí®æ, ( Ãþ¦ü¥Î¼Ï¯Ã¤ÀªR©Ô¥X¨Óªº®æ¦¡)
¦b§ÚTest reportªºEXCEL "¾÷¥x¼Æ"ªº¤À¶, ¥h°µ¤@ÓÃþ¦ü¤ÀªR¸ê®Æ
¤U¸ü
(18.07 KB)
2017-8-15 15:25
¤U¸ü
(8.48 KB)
2017-8-15 15:25
µ{¦¡¨BÆJ¬O, ¶}±ÒTest Report ¦A¥´¶}"°Ñ¦Ò¸ê®Æ" ¡÷ ¦A«ö²£¥Í³øªí
µ{¦¡·|±q°Ñ¦Ò¸ê®Æ§ì¨únªº¸ê®Æ¨ìTest report ¥h°µ¸ê®Æ·J¾ã
ª½¨ìMoudle3¡y¾÷¥x¼Æ¡z ¥u¬O§â°Ñ¦Ò¸ê®Æ¤¤§Únªº¸ê®Æ§ì¹L¨Ó, ¦A°µ¤@Ó¿z¿ï
³Ñ¤Uªº¸ê®Æn°µ¤ÀªRªº
Q1: ¯à§_±NMoudle3 ¿z¿ï§¹ªº¸ê®Æ¦b¦P¤@Ó¤À¶ ¡y¾÷¥x¼Æ¡z §e²{¥X ¤W¹Ïªº¸ê®Æ©O?
¦pªGPKG¬OªÅ¥Õ¥Nªí¾÷¥x«Ý®Æ, ¥i§_§â
ªÅ¥Õ¦r²´´«¦¨" «Ý®Æ "
¤U¸ü
(11.22 KB)
2017-8-15 15:26
¢ß2: ¯à§_±N¤ÀªR§¹ªº¸ê®Æ¦A¶×¤JFMC »P ENG ªº¸ê®Æªí¤º
¤U¸ü
(4.78 KB)
2017-8-15 15:27
¤U¸ü
(13.41 KB)
2017-8-15 15:27
test2.rar
(750.09 KB)
¤U¸ü¦¸¼Æ: 3
2017-8-15 15:29
¼Ó¥D¼ö©«
½Ð°Ý¥X¶Ô¨t²Î³]p
«½Æ¤º®e®É¶¡¥[Á`¨Ã§R°£«½Æ«O¯d°ß¤@È
¨Ì·Ó³øªí§ë½u¶q»PUPH<¨C¤p®É²£¯à>pºâ¶}¾÷¼Æ
¸óÄæ¸m¤¤»PÂ^¨ú¤å¦r°ÝÃD
¸ê®ÆåªR+¥[®Ø½u
¿é¤J¸ê®Æ¤ñ¹ï¸ê®Æªí Âà´«¨ì§Oªº¸ê®Æªí
¦r¦ê¤¤¨S¦³¥]§t¬Y¦r¤¸¥Îªk
VBA ªí³æ¥\¯àµo°Ý
Range'¤èªk('_Global'ª«¥ó)¥¢±Ñ
§Q¥Î¤@Ó¥¨¶°¡A½Æ»sAÀɮרìBÀÉ®×°ÝÃD
¦¬ÂÃ
¤À¨É
v03586
µoµu®ø®§
¥[¬°¦n¤Í
v03586
·í«eÂ÷½u
UID
22132
©«¤l
193
¥DÃD
29
ºëµØ
0
¿n¤À
222
ª÷¿ú
222
ÂI¦W
0
§@·~¨t²Î
Windows7
³nÅ骩¥»
OFFICE2013
¾\ŪÅv
20
¦b½u®É¶¡
250 ¤p®É
µù¥U®É¶¡
2015-9-18
³Ì«áµn¿ý
2023-4-29
¤¤¾Ç¥Í
©«¤l
193
¥DÃD
29
ºëµØ
0
¿n¤À
222
ÂI¦W
0
§@·~¨t²Î
Windows7
³nÅ骩¥»
OFFICE2013
¾\ŪÅv
20
µù¥U®É¶¡
2015-9-18
³Ì«áµn¿ý
2023-4-29
2
#
µoªí©ó 2017-8-24 12:17
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
v03586
½Ð°Ý¤@¤U...§Ú¤w¸g±N¤Wz°ÝÃD¿ý»s¼Ï¯Ã¤ÀªR, ¦p¤Uµ{¦¡½X
½Ð°Ý§Ún¦p¦ó§Q¥Î°j°éor §PÂ_¦¡ ±N¼Ï¯Ã¤ÀªRµ²ªG, ¾É¤J¨ìFMC¸ê®ÆÄ檺¾÷¥x¼Æ©O??
¤U¸ü
(12.39 KB)
2017-8-24 12:15
¤U¸ü
(4.78 KB)
2017-8-24 12:15
¤U¸ü
(13.41 KB)
2017-8-24 12:17
Test.rar
(762.02 KB)
¤U¸ü¦¸¼Æ: 1
2017-8-24 12:16
Sub ¾÷¥x¼Æ¤ÀªR()
Application.CutCopyMode = False
Range("A1").Select
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"¾÷¥x¼Æ!R1C1:R144C16", Version:=xlPivotTableVersion15).CreatePivotTable _
TableDestination:="¾÷¥x¼Æ!R1C17", TableName:="¼Ï¯Ã¤ÀªRªí1", DefaultVersion:= _
xlPivotTableVersion15
Sheets("¾÷¥x¼Æ").Select
Cells(1, 17).Select
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 6
With ActiveSheet.PivotTables("¼Ï¯Ã¤ÀªRªí1").PivotFields("Package")
.Orientation = xlRowField
.Position = 1
End With
ActiveSheet.PivotTables("¼Ï¯Ã¤ÀªRªí1").AddDataField ActiveSheet.PivotTables("¼Ï¯Ã¤ÀªRªí1" _
).PivotFields("Machine"), "p¼Æ - Machine", xlCount
ActiveWindow.ScrollColumn = 7
ActiveWindow.ScrollColumn = 8
With ActiveSheet.PivotTables("¼Ï¯Ã¤ÀªRªí1").PivotFields("Area")
.Orientation = xlPageField
.Position = 1
End With
ActiveSheet.PivotTables("¼Ï¯Ã¤ÀªRªí1").PivotFields("Area").ClearAllFilters
ActiveSheet.PivotTables("¼Ï¯Ã¤ÀªRªí1").PivotFields("Area").CurrentPage = "HQ4F-FMC"
End Sub
½Æ»s¥N½X
TOP
ÀR«ä¦Û¦b :
¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·