copy paste

C

Complexx

This is in english.

Hi,

Atm i am working as officemanager.

i have a problem with excell..
oftenly i get contactlists with clients information. the lines in that are
very long with adresses etc.

i want that in 1 alinea and 3 lines under eachother. with a little extra
space for notes

atm i keep copy and pasting in another sheet it takes a lot of time and i
think thats not necessary.

Regards, Mark Reckman
 
K

kassie

You do not say whether the details are in columns, all in one row, or just in
one cell?

You could record a macro that would cycle through the worksheet, insert the
required number of rows between 2 used rows, and then move the data from the
adjoining columns (B,C,D etc) to the inserted rows. Save macro in your
personal.xls, so that the macro is available at all times.
 
Top