| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need a macro.
this is the sample of my spreadsheet.
column A B C ----------------------------------------- N001 numbers N002 numbers N003 numbers 101 N004 day numbers N005 day numbers N006 day numbers N007 day numbers this is sample what I need to replaced. column A B C ----------------------------------------- N001 yes text N002 yes text N003 no text 101 N004 day text N005 day text N006 day text N007 day text pls help for create a macro. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need a macro.
What is the logic behind changing the original sample to the replaced sample?
i.e. Why should the blanks change to yes or no? Why should the numbers turn into text? Gord Dibben MS Excel MVP On Thu, 22 Nov 2007 06:10:01 -0800, Johnny wrote: this is the sample of my spreadsheet. column A B C ----------------------------------------- N001 numbers N002 numbers N003 numbers 101 N004 day numbers N005 day numbers N006 day numbers N007 day numbers this is sample what I need to replaced. column A B C ----------------------------------------- N001 yes text N002 yes text N003 no text 101 N004 day text N005 day text N006 day text N007 day text pls help for create a macro. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Linear Mode
