+ Reply to Thread
Results 1 to 4 of 4

copying text from alternate cells

  1. #1
    Registered User
    Join Date
    02-20-2006
    Posts
    3

    copying text from alternate cells

    Hi,

    I need to copy text from cells A2, A4, A6 and so on.

    Could someone please give a formula for this?

    Thanks,
    EL.

  2. #2
    Ardus Petus
    Guest

    Re: copying text from alternate cells

    Where do you want to copy your data to?

    That might be done with formulas, not VBA.
    --
    AP

    "excel_lent" <excel_lent.269kqn_1145034601.7054@excelforum-nospam.com> a
    écrit dans le message de
    news:excel_lent.269kqn_1145034601.7054@excelforum-nospam.com...
    >
    > Hi,
    >
    > I need to copy text from cells A2, A4, A6 and so on.
    >
    > Could someone please give a formula for this?
    >
    > Thanks,
    > EL.
    >
    >
    > --
    > excel_lent
    > ------------------------------------------------------------------------
    > excel_lent's Profile:

    http://www.excelforum.com/member.php...o&userid=31738
    > View this thread: http://www.excelforum.com/showthread...hreadid=532982
    >




  3. #3
    Registered User
    Join Date
    02-20-2006
    Posts
    3
    AP,

    I want to copy text from cells A2, A4, A6, etc into cells B1, B2, B3 etc.

    Thanks
    EL.

  4. #4
    Ardus Petus
    Guest

    Re: copying text from alternate cells

    In B1 (then copy down):
    =INDEX(A:A,ROW()*2)

    HTH
    --
    AP
    "excel_lent" <excel_lent.269nio_1145038205.6523@excelforum-nospam.com> a
    écrit dans le message de
    news:excel_lent.269nio_1145038205.6523@excelforum-nospam.com...
    >
    > AP,
    >
    > I want to copy text from cells A2, A4, A6, etc into cells B1, B2, B3
    > etc.
    >
    > Thanks
    > EL.
    >
    >
    > --
    > excel_lent
    > ------------------------------------------------------------------------
    > excel_lent's Profile:

    http://www.excelforum.com/member.php...o&userid=31738
    > View this thread: http://www.excelforum.com/showthread...hreadid=532982
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1