ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

vba¼gªk

vba¼gªk

¥»©«³Ì«á¥Ñ sillykin ©ó 2020-12-30 00:13 ½s¿è

C6~c200
C6=IF(D6="","",$C$4)
C7=IF(D7="","",$C$4)
C8=IF(D8="","",$C$4)
¦ÜC200
---------------------------------------------------
F6~F200
F6¤½¦¡=IF(ISNA(VLOOKUP($A6,»¡©ú!$B:$E,3,FALSE)),"",(VLOOKUP($A6,»¡©ú!$B:$E,3,FALSE)))
F7¤½¦¡=IF(ISNA(VLOOKUP($A7,»¡©ú!$B:$E,3,FALSE)),"",(VLOOKUP($A7,»¡©ú!$B:$E,3,FALSE)))
F8¤½¦¡=IF(ISNA(VLOOKUP($A8,»¡©ú!$B:$E,3,FALSE)),"",(VLOOKUP($A8,»¡©ú!$B:$E,3,FALSE)))
¦ÜF200
G6~G200
G6=IF(ISNA(VLOOKUP($A6,»¡©ú!$B:$E,4,FALSE)),"",(VLOOKUP($A6,»¡©ú!$B:$E,4,FALSE)))
G7=IF(ISNA(VLOOKUP($A7,»¡©ú!$B:$E,4,FALSE)),"",(VLOOKUP($A7,»¡©ú!$B:$E,4,FALSE)))
¦ÜG200
·Q½Ð°Ý­n¦p¦ó¥ÎVBAªí¥Ü

¥»©«³Ì«á¥Ñ n7822123 ©ó 2020-12-30 00:38 ½s¿è

¦^´_ 1# sillykin

¥ÎVBA§å¦¸¼g¤½¦¡¶Ü~?

C6~c200
C6=IF(D6="","",$C$4)
C7=IF(D7="","",$C$4)
C8=IF(D8="","",$C$4)
¦ÜC200

[C6:C200] = "=IF(D6="""","""",$C$4)"

F6~F200
F6¤½¦¡=IF(ISNA(VLOOKUP($A6,»¡©ú!$B:$E,3,FALSE)),"",(VLOOKUP($A6,»¡©ú!$B:$E,3,FALSE)))
F7¤½¦¡=IF(ISNA(VLOOKUP($A7,»¡©ú!$B:$E,3,FALSE)),"",(VLOOKUP($A7,»¡©ú!$B:$E,3,FALSE)))
F8¤½¦¡=IF(ISNA(VLOOKUP($A8,»¡©ú!$B:$E,3,FALSE)),"",(VLOOKUP($A8,»¡©ú!$B:$E,3,FALSE)))
¦ÜF200

[F6:F200] = "=IF(ISNA(VLOOKUP($A6,»¡©ú!$B:$E,3,FALSE)),"""",(VLOOKUP($A6,»¡©ú!$B:$E,3,FALSE)))"

G6~G200
G6=IF(ISNA(VLOOKUP($A6,»¡©ú!$B:$E,4,FALSE)),"",(VLOOKUP($A6,»¡©ú!$B:$E,4,FALSE)))
G7=IF(ISNA(VLOOKUP($A7,»¡©ú!$B:$E,4,FALSE)),"",(VLOOKUP($A7,»¡©ú!$B:$E,4,FALSE)))
¦ÜG200

[G6:G200] = "=IF(ISNA(VLOOKUP($A6,»¡©ú!$B:$E,4,FALSE)),"""",(VLOOKUP($A6,»¡©ú!$B:$E,4,FALSE)))"

¤£­nÃhºÃ¡A´N¬O³o»ò²³æ~

µ{¦¡¤ñ§Aªº»¡©úÁÙ¤Ö~ ^.^
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD