Copy and paste to the end of an Excel List

[Phil Smith]

I'm new to VBA.

I have a project to collect some data about assets.

I want to be able to write some code which
1. copies a column of 9 or 10 cells (Range
Named "NewItem", Paste-Special Transposes the data and
2. then appends it to the end of an excel list.

I know how to do the first bit, but it's the second bit
thats causing the problems. I would like to be able to
work out the code myself. Can anyone give me a clue how
it might be done?

Regards

 

[Michael J. Malinsky]

Ok, you got the first part where you have the range copied. Here's how to
do it manually, you can try to figure out the code since that's what you
want to do (and sometimes trial and error is the best way to learn, IMHO).

After the range is copied, go to the sheet that contains your list. Go to
cell A65535 (assuming your list begins in column A) then do Ctrl+up arrow,
then down one cell. Then you can paste special>transpose to this new blank
row.

Post back if you need more hints!

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[Phil]

Thanks

-----Original Message-----
Ok, you got the first part where you have the range copied. Here's how to
do it manually, you can try to figure out the code since that's what you
want to do (and sometimes trial and error is the best way to learn, IMHO).

After the range is copied, go to the sheet that contains your list. Go to
cell A65535 (assuming your list begins in column A) then do Ctrl+up arrow,
then down one cell. Then you can paste special>transpose to this new blank
row.

Post back if you need more hints!

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain




.

 

[twollens]

WhatI have done in this case (since I am not good with VBA yet) is
record a macro and then look at the macro code.

Not sure if it will help you, but has helped me.