copy(or cut)/paste from column to row

[Oshi]

Hi.

I'm looking for a macro that will copy and paste data from a column in one worksheet to the next empty row in another worksheet. I've found a few that do row to row, but I can't figure out how to do column to row.

Also, since the first page is a data entry form I wonder if the same macro can clear the cells in the column from sheet 1, but leave the formulas that are in a few cells.

And lastly, would it be possible to have the destination sheet for the copy change per the date in the first cell being copied? IE January, February, etc. This one isn't really neccessary at all, just wondered about it.

[Paul]

Hi Oshi,

Regarding your first question, about transposing data from one sheet to another, something like this should get you close:

Please Login or Register  to view this content.

As for your second and third questions, you'll have to provide a bit more details as to which cells you'd like to keep (or under what conditions) and which should be cleared, etc.

It might be easiest to post a zipped copy of your workbook to the forum and put specific notes inside showing what you'd like done and what the result should be.