I'm attempting to figure out how to copy a variable length of data
from one worksheet to another. They're both in the same work book.
One sheet is the Order sheet and the other is a credit card tracking
sheet. The columns don't match up and are orientated for ease of
reading for the particular information we need to know from each one.

So essentially i have no problem combining multiple macros, one for
each column... i just can't figure it out =)

Excel 2003, trying to use Macros...


Jonathan Nies

hi
here is a simple macro that copies 1 column of data (regardless of data
length) from sheet 1 to sheet 2. put it in a standard module. it's a tad
wordy but i did so to show the logical steps the macro takes.
Sub copystuff()
Dim rng1
Dim rng2
Sheets("Sheet1").Activate
Set rng1 = Range("A1")
Set rng2 = Range("A65000").End(xlUp)
Range(rng1, rng2).Select
Selection.Copy
Sheets("sheet2").Activate
Range("A1").Select
ActiveSheet.Paste
End Sub

you may have to modify to fit your data. you can add on the the end to copy
more columns.
post back if you have problems/questions.

Regards
FSt1

"(E-Mail Removed)" wrote:

> I'm attempting to figure out how to copy a variable length of data
> from one worksheet to another. They're both in the same work book.
> One sheet is the Order sheet and the other is a credit card tracking
> sheet. The columns don't match up and are orientated for ease of
> reading for the particular information we need to know from each one.
>
> So essentially i have no problem combining multiple macros, one for
> each column... i just can't figure it out =)
>
> Excel 2003, trying to use Macros...
>
>
> Jonathan Nies
>
>