+ Reply to Thread
Results 1 to 7 of 7

Copying cells

  1. #1
    Registered User
    Join Date
    05-31-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    37

    Copying cells

    hello, I am new to these forums, let me know if i need to post anything else
    What I want to do is the following:

    Copy 3 colums from a row of another sheet into 3 rows of the same colum to my current sheet. And then keep on doing this 67 times. Like this...

    F3 I3
    G3 J3
    H3 K3
    skip a row
    F4 I4
    G4 J4
    H4 K4
    skip a row
    F5 I5
    G5 J5
    H5 K5
    skip a row
    .....
    .....
    ..... and so on
    My Columns go from F to BP an rows from 3 to 261 so as you can see it would be quite repetitive to hand enter all the values.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Copying cells

    Hi tactical and welcome to the forum. Perhaps you should post a mock workbook with desired results.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Registered User
    Join Date
    05-31-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Copying cells

    Where can this mock workbook be found?

  4. #4
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Copying cells

    You'd have to make one with some examples of data and then an example of what exactly it is you want done with the data.

  5. #5
    Registered User
    Join Date
    05-31-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Copying cells

    Where do I upload this mock workbook?

  6. #6
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Copying cells

    Click "Go Advanced" and when the next screen comes up click on the "Attachments" paper clip icon and the follow the prompts.

  7. #7
    Registered User
    Join Date
    05-31-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Copying cells

    attachment is uploaded
    Again, I just want to be able to do the first row and or column, then just drag and drop and have the rest of the values copied.
    Attached Files Attached Files
    Last edited by tactical; 05-31-2011 at 01:22 PM.

+ 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