Macro to insert rows and concatenate text

[macro]

Hi All,

I'm trying to create macro where i can insert rows and concatenate it with
text, but it has to be from cursor position.

I think i need to modify the syntax in the module, but i don't know how the
syntax should be formed (newbie to macro)

Appreciate if you can help me with the syntax, because i have thousands
lines need to be inserted :::::


Thanks in advance for your advices.

 

[Rick Rothstein]

I'm trying to create macro where i can insert rows and concatenate
it with text, but it has to be from cursor position.

Can you provide more detail on this so we will have an idea of exactly what
you are trying to accomplish? If you can give us a couple of examples of
before and after, that would help a lot.

 

[macro]

Hi Rick,

Thanks for replying.

I actually wanna insert couple of rows under certain row and fill in the
cell by adding digits in column A and concatenate text in column B. It has to
be able to insert the new rows starting from wherever rows the cursor is
pointing to.

For example:

original row highlight by cursor is Row 10, which Column A has ID XX100, and
Column B has text "original text1", and addtionional text in cell C1
("addition")

I want the macro to insert 4 rows under Row 10, and then populate ID in
Column A by adding (01) --> result would be XX10010. In Column B, after
concatenation between column B and reference cell, it would be "original
text1 - addition".


Thanks a lot for the advice. Really appreciate it.