Hey all....

I have never used macros before, but here goes....

I have alot of data that looks like this ( the dashes are for spacin
purposes since html is off in postings):

----A------------B--------------C
1 sample----data---------example
2 ------------more
3 sample----data---------example
4 -------------more

(no, it's not all the same info, nor always in the same place or
would use a recorded macro)

what I need is a macro to see that A2 is empty and take cell B2 an
append the contents of cell B2 to B1 so that B1 says "data more
instead of just "data"

and do this for the whole worksheet

I have been trying to look into copy and paste for macros, but
straight "copy" and "paste" won't work as it will overwrite the curren
contents of the cell being pasted to.

I have thousands upon thousands of lines I would like to combin
without having to do it all by hand.

Any ideas? Remember, I'm a newbie to excel, but not so new I can'
comprehend... thanks

Bil

--
billbeecha
-----------------------------------------------------------------------
billbeecham's Profile: http://www.excelforum.com/member.php...fo&userid=1628
View this thread: http://www.excelforum.com/showthread.php?threadid=27688