+ Reply to Thread
Results 1 to 4 of 4

joining data from two sheets

  1. #1
    Registered User
    Join Date
    01-12-2009
    Location
    Bucharest
    MS-Off Ver
    Excel 2003
    Posts
    2

    joining data from two sheets

    Hi all,

    I have a small problem, i have to excel sheets 2003, and i need to bring data from the first sheet fist column, to the sencond sheet in the 3 column, but ...i think i should give an example of what i need :

    sheet 1 sheet2

    column 1 column3
    data1
    data2
    data3 data1
    data4
    data5
    . data2
    .
    .
    . data3
    data6 .
    . .
    . .
    . .
    . etc
    etc

    Th idea is that i need to make somthing automatic of this , bring the data from sheet one in the spesific position in sheet two, the distance between the data in the sheet 2 is the same , around 12 rows

    Please help
    Thanks
    Last edited by bugmero; 01-12-2009 at 06:04 PM.

  2. #2
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465
    Hello bugmero,

    Is this =+Sheet2!A1 is your answer.
    __________________
    Regards
    Rahul Nagar
    Founder of www.myshortcutkeys.com.


    If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
    Also
    If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

  3. #3
    Registered User
    Join Date
    01-12-2009
    Location
    Bucharest
    MS-Off Ver
    Excel 2003
    Posts
    2
    Thanks a lot, yes this is exactly what i needed , i'm sorry for my bad explaining of what i need .

    Again thanks a million

  4. #4
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465
    Hello again,

    If you receive a solution..

    Please mark thread as a solved

    1)Click the EDIT button on your first post
    2)Click the GO ADVANCED button
    3)Select SOLVED from the Title dropdown (under the Reason for Editing box
    4)Click the SAVE CHANGES button

+ 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