Macro Paste data in next column instead of next row below

[jh51745]

Instead of pasting to the next row the macro pastes to next column and the format is not the same.

Please Login or Register  to view this content.

[ragulduy]

If you want to keep the formats, change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

to change from next column to next row, you basically need to swap everything where you have something like:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[jh51745]

When I save all the values change in my new sheet. May have forgot to mention that I am copying a value that is a result of a formula from that cell. It also skips five lines before pasting in new set of data.

[ragulduy]

ok, keep the method you had and use

Please Login or Register  to view this content.

as well to move the formats across.

Not sure about skipping the lines, can you post the code after you have changed it?