Hi Guys,

Can anyone help me with making a macro to copy and paste a cell.


Here’s the sample data

A B C D
1 Code1 Tom Jones
2 deny
3 credit
4 Code2 Jim Tyles
5 good
6 Code3 Sam King
7 bad credit

I need the macro to look into column A and look for blank cells. I
there’s a blank cell, it needs to copy the row starting with A to K an
paste it column L or in the row before that blank cell and if there
another blank cell after the first one, it needs to copy and paste i
column W and then loops again till it finds another blank cell.

It needs to look like this:

A B C D L W
1 Code1 Tom Jones deny credit
2 deny
3 credit
4 Code2 Jim Tyles good
5 good
6 Code3 Sam King bad credit
7 bad credit

Hope you can help guys, this is just part of what I need to do with
raw data. I just made a macro to reformat the sheet. And, this kin
of macro is too complex for me :(

Thanks in advanc

--
japorm
-----------------------------------------------------------------------
japorms's Profile: http://www.excelforum.com/member.php...nfo&userid=654
View this thread: http://www.excelforum.com/showthread.php?threadid=56246