Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have the following info in a worksheet: A1 B1 C1 55KL 85.25 ER200 I would like to create a macro that would generate the following sentence in cell A3: 55 85,25 200 Please note that the point in cell B1 was changed with a comma in the sentence. I have a form with this setting repeating many times, so it would be nice if the solution involves the active cell and the cells above it from which the sentence is created instead of specific cell names. This is a simplify version of what I really need to get done, but it has the basic idea of what Im trying to achieve. Any guidance would be greatly appreciated. Edwin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating macros | Excel Discussion (Misc queries) | |||
creating a macros and repeating it | Excel Discussion (Misc queries) | |||
macros creating | Excel Discussion (Misc queries) | |||
creating macros in excel | Excel Discussion (Misc queries) | |||
Macros-creating new sheets | Excel Worksheet Functions |