Moving data from column and pasting to bottom of next column

[Datagirl8472]

Hi there

I have a pickle - can anyone help. I've atached a test database to hopefully explain as I'm not sure what sense this is going to make.....

I have a spreadsheet, with many coloumns. I want to get all the data going downwards in a single column (as per sheet 2) instead of being split over multiple columns. The "constant" column must be copied though alongside each section of moved data,,,,,I'm really struggling to explain it in words - could you take a look at the attached and see?

Please let me know if you need any more information!!

ThanksExample.xlsxExample.xlsx

[xladept]

Hi Datagirl,

Sheet 2 is blank??

[Datagirl8472]

Example.xlsxah. Apparenly I'm an idiot! Sorry!! Will Try again!!

Hopefully this helps!

[AB33]

There is a button on sheet1

[xladept]

Hi Datagirl,

Here's another version:

Please Login or Register  to view this content.

[Datagirl8472]

Thanks so much for your help. I'm just attempting to make this work with my data - fingers crossed!!
If either of you get chance, is there any chance you could annotate the code so I know what does what? I'm trying to improve my knowledge of VBA and if I can see which commands are doing what, I'm hoping that will hope me understand things further

Thanks again,

DataGirl

[xladept]

Hi DGirl,

Hope this helps:

Please Login or Register  to view this content.