Copy and Paste

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

Hi

How do I copy and paste two seperate lists, in Sheet1 and Sheet2, an
make one list.
Sheet1 and Sheet2 are different in row lenght
But not different in columns.
the result (one list) should go in Sheet3
Click to expand...


Please help:)

Stephe
 
Hi Stephen,

I'm not sure if I am understanding your question. But, if
both sheet have the same number of column's and, one sheet
has more rows than the other, then try.

In the sheet with the most rows, highlight each column and
use Ctrl+C, go to sheet 3, put the cursor in A1 and use
Ctrl+V. While in sheet 3 select Ctrl+End move the cursor
to the first available row in Column A (say A1000), Now
select the sheet with the least rows, Highlight Each Row
that contains data, use Ctrl+C. Go to sheet 3 and with the
Cursor still in A1000 use Ctrl+V.

Did I answer your Question?

Charlie O'Neill
 
Hi Charlie

What I am looking for is how it is done in Visual Basic. That's why
asked this in the >Excel Programming> Forum.

Thanks anyway for responding:) Should you have a solution for thi
"challenge", then I'll be very gratefull.

Stephen
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My Never ending ARRAY code problems 18
loop to copy paste 5
Automated Copy Paste 1
Excel Moving data to sheet2 from sheet1 0
conditional copy and paste 11
How to copy several nonajacent cells and paste to ajacent cells in one row 7
Sheet to sheet code Type Mismatch 6
Copy contiguous from one sheet and paste to another every other ro 1

Back
Top