Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill question
Hi, I'm trying to do this Code: -------------------- --------------------------- | B | C | |-------------------------| | vic | vic2fxs | when I write vic2fxs in the C column it autofill B column with vic | vic | vic2bri | when I write vic2bri in the C column it autofill B column with vic | vic | vic4fxs | when I write vic4fxs in the C column it autofill B column with vic | wic | wic1-enet | when I write wic-1-enet in the C column it autofill B column with wic | switch | sw2950 | when I write sw2950 in the C column it autofill B column with switch --------------------------- -------------------- Help me to resolve this question...and sorry for my english Thanks -- darksides ------------------------------------------------------------------------ darksides's Profile: http://www.excelforum.com/member.php...o&userid=37595 View this thread: http://www.excelforum.com/showthread...hreadid=572211 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill question
This can be done without code:
B1 = "=If(C1 = "","",If(Left(C1,2) = "sw","switch",Left(C1,3))" HTH Charles darksides wrote: Hi, I'm trying to do this Code: -------------------- --------------------------- | B | C | |-------------------------| | vic | vic2fxs | when I write vic2fxs in the C column it autofill B column with vic | vic | vic2bri | when I write vic2bri in the C column it autofill B column with vic | vic | vic4fxs | when I write vic4fxs in the C column it autofill B column with vic | wic | wic1-enet | when I write wic-1-enet in the C column it autofill B column with wic | switch | sw2950 | when I write sw2950 in the C column it autofill B column with switch --------------------------- -------------------- Help me to resolve this question...and sorry for my english Thanks -- darksides ------------------------------------------------------------------------ darksides's Profile: http://www.excelforum.com/member.php...o&userid=37595 View this thread: http://www.excelforum.com/showthread...hreadid=572211 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill question | Excel Discussion (Misc queries) | |||
Autofill Question | Excel Worksheet Functions | |||
Autofill question | Excel Worksheet Functions | |||
Q. Autofill question: Can I autofill alpha characters like I can numbers? | Excel Programming | |||
Autofill question | Excel Programming |