| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
?macro help-insert copy-w/o overwriting what is already there
Hi- appreciate any help. I do not know how to do anything but record a macro.
I want to insert a number "454-2381 x" before an extension. Like I record the macro in the first cell. then when I play it in the 2nd cell it overwrite the extension that is there & puts in the same extension in the first cell. 454-2381 x15394 15391 15363 15209 15211 Can anyone help me?? THANK YOU SO MUCH IN ADVANCE!! HARRIET |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
?macro help-insert copy-w/o overwriting what is already there
Hi Jim,
thanks tons for the reply!! I did that & this is what I got: 454-2381 xDisplay Name it replaced it with "Display Name" Can ya help me more? "harriet" wrote: Hi- appreciate any help. I do not know how to do anything but record a macro. I want to insert a number "454-2381 x" before an extension. Like I record the macro in the first cell. then when I play it in the 2nd cell it overwrite the extension that is there & puts in the same extension in the first cell. 454-2381 x15394 15391 15363 15209 15211 Can anyone help me?? THANK YOU SO MUCH IN ADVANCE!! HARRIET |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
?macro help-insert copy-w/o overwriting what is already there
Why not just use a formula in an adjacent column something like
="454-2381 x" & A2 where the extension is in A2. If you need a macro solution then I just need to know if you intend to select the cells you want to update or is it all of the cells in the column or ??? I assume it is the same phone number for each? -- HTH... Jim Thomlinson "harriet" wrote: Hi- appreciate any help. I do not know how to do anything but record a macro. I want to insert a number "454-2381 x" before an extension. Like I record the macro in the first cell. then when I play it in the 2nd cell it overwrite the extension that is there & puts in the same extension in the first cell. 454-2381 x15394 15391 15363 15209 15211 Can anyone help me?? THANK YOU SO MUCH IN ADVANCE!! HARRIET |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
?macro help-insert copy-w/o overwriting what is already there
Guess what JIm - the dumme (me) figured the other thing out.
Your just super - thanks for helping me out!!! "harriet" wrote: Hi Jim, thanks tons for the reply!! I did that & this is what I got: 454-2381 xDisplay Name it replaced it with "Display Name" Can ya help me more? "harriet" wrote: Hi- appreciate any help. I do not know how to do anything but record a macro. I want to insert a number "454-2381 x" before an extension. Like I record the macro in the first cell. then when I play it in the 2nd cell it overwrite the extension that is there & puts in the same extension in the first cell. 454-2381 x15394 15391 15363 15209 15211 Can anyone help me?? THANK YOU SO MUCH IN ADVANCE!! HARRIET |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert rows automatically to avoid overwriting | Excel Discussion (Misc queries) | |||
| Stop Overwriting (Fill, Copy, etc) Data Validation | Excel Discussion (Misc queries) | |||
| Macro - Insert/Copy | Excel Discussion (Misc queries) | |||
| Copy calendar entries without overwriting date? | Excel Discussion (Misc queries) | |||
| copy insert macro | Excel Programming | |||
Linear Mode
