In Excel > I would like to create a macro to copy multiple rows to 1 row on another excel spreads

[gennaroalpha7]

Hi -

I would like to create a macro to copy (4 or 5) multiple rows to 1 row on another excel spreadsheet. Can this be completed.

Pleas be specific and elaborate - I have never created a macro before...help!


Thx.

G.

 

[gennaroalpha7]

Thanks you both for your help. I will try your code and check it out.

Have a good one.

G

 

[gennaroalpha7]

Vilhelm-Ion Praisach, how do I use your code. Where do I enter it...would i use the macro recorder?

Thanks.

G.

 

[vgulielmus]

The following links describe what you have to do.

http://office.microsoft.com/en-us/excel-help/run-a-macro-HP010342865.aspx

http://office.microsoft.com/en-us/excel-help/create-or-delete-a-macro-HP010014111.aspx

Also save as xlsm (macro-enabled workbook) the workbook from where you run the macro.

My respects,
Vilhelm-Ion Praisach
Resita, Romania