Results 1 to 2 of 2

Copy datas same line different rows to other cells

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2013
    Location
    Work
    MS-Off Ver
    Excel 2003
    Posts
    1

    Copy datas same line different rows to other cells

    Good morning to everyone,
    I hope to be clear enough as English it's not my mother tongue.

    Here is my problem:
    I'd like to copy data from various cell placed on the same lime but at a, fixed, different row position, without having to tape it manually.

    I had a look on the net but between my inexperience and the differences in language (my excel is in localized in Italian), I'm having some rough time figuring it out!

    This is what I would like to do:
    copy Value from =Sheet1!A:10 - =Sheet1!E:10 - =Sheet1!J:10 - =Sheet1!O:10 (from every 5th row in Sheet1 for couple 100th times)
    to Sheet2 A:10 - B:10 - C:10 - D:10 (filling every cell on a fixed line in Sheet2).

    Like all newbies i tried writing down manually, couple of times, the cells from which the data should be taken and then i tried to drag hoping it would recognize the pattern: naturally it doesn't work.

    If I input the first 2 or 3 (=Sheet1!A:10 in A:10, =Sheet1!E:10 in B:10, =Sheet1!J:10 in C:10) and then drag it goes with the very next one following (=Sheet1!K:10).

    Please point me to something that can help me sort this out!
    Thanks.
    Last edited by freejack; 06-22-2013 at 05:16 PM. Reason: Be more clear

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