Results 1 to 12 of 12

Copying cells to the neighbouring column in pairs along Row 1

Threaded View

  1. #1
    Registered User
    Join Date
    06-25-2007
    Posts
    45

    Copying cells to the neighbouring column in pairs along Row 1

    Hi,

    So I have a spreadsheet that has a Title in Cell A1, then entries in B1, D1, F1, H1, J1, etc... with empty cells between.

    What I would like to do is copy those entries to the right, i.e. B1 into C1, D1 into E1, F1 into H1, but all the way along because in my master sheet there are a lot of columns.

    The attached spreadsheet shows exactly what I'm hoping for; any help is much appreciated!

    Many thanks,

    Tim
    Attached Files Attached Files
    Last edited by shmee150; 03-13-2009 at 12:23 PM.

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