rrtts
12-06-2006, 04:25 PM
In my worksheet, I have about 30 column headings...each with varying amount of cells that contain data below the headings.
What I'm trying to figure out how to do is copy the headings that have cells that contain data and the actual cells that have data into a single column.
Obviously the "record macro" isn't going to assist me much with trying to figure out the code to do this...so hopefully one of you brilliant excel/vb programmers can lend a hand.
I've tried to illustrate what I'm trying to achieve in a worksheet (attached).
Appreciate any and all help. Thanks a bunch.
What I'm trying to figure out how to do is copy the headings that have cells that contain data and the actual cells that have data into a single column.
Obviously the "record macro" isn't going to assist me much with trying to figure out the code to do this...so hopefully one of you brilliant excel/vb programmers can lend a hand.
I've tried to illustrate what I'm trying to achieve in a worksheet (attached).
Appreciate any and all help. Thanks a bunch.