+ Reply to Thread
Results 1 to 17 of 17

pulling data from one sheet to another in a workdata which can be refreshed in excel.

Hybrid View

krisuk pulling data from one sheet... 04-16-2013, 12:16 PM
dilipandey Re: pulling data from one... 04-21-2013, 09:46 AM
krisuk Re: pulling data from one... 04-21-2013, 02:34 PM
dilipandey Re: pulling data from one... 04-21-2013, 02:56 PM
krisuk Re: pulling data from one... 04-21-2013, 03:20 PM
dilipandey Re: pulling data from one... 04-21-2013, 02:55 PM
dilipandey Re: pulling data from one... 04-21-2013, 03:24 PM
krisuk Re: pulling data from one... 04-21-2013, 03:40 PM
krisuk Re: pulling data from one... 04-21-2013, 03:36 PM
dilipandey Re: pulling data from one... 04-22-2013, 03:36 AM
krisuk Re: pulling data from one... 04-22-2013, 05:26 AM
dilipandey Re: pulling data from one... 04-22-2013, 06:51 AM
krisuk Re: pulling data from one... 04-22-2013, 07:50 AM
krisuk Re: pulling data from one... 04-22-2013, 07:47 AM
dilipandey Re: pulling data from one... 04-22-2013, 08:53 AM
krisuk Re: pulling data from one... 04-22-2013, 10:23 AM
dilipandey Re: pulling data from one... 04-22-2013, 03:00 PM
  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    pulling data from one sheet to another in a workdata which can be refreshed in excel.

    Hi
    I used microsoft query to pull data but unfornatunately the data is in multiply tables so I now want to join the table in order for the data to make sense.
    Please see the attached excel workbook.
    Thanks for your help in advance
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    Hi Krisuk,

    welcome to the forum.

    In sheet "aim to achieve this", how you will get values in column G:M.
    I got that column C:F, you can get from sheet2


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    04-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    Hi DILIPandey,
    G:M was picked from E:J in sheet 1.
    Hope this helps you to understand it better.
    Thanks

    krisuk

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    I found "DocumentNo" field in sheet2 and I am thinking if this field is there is sheet 1 as well, then we can easily extract complete row. Thanks.




    Regards,
    DILIPandey
    <click on below * if this helps>

  5. #5
    Registered User
    Join Date
    04-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    The common field is POPOrderReturnID.

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    Hi Krisuk,

    Is there any common field (column) between sheet 1 and sheet 2 as this may help in getting information from both the sheets ?
    Also, can you manually put in two rows of data basis these two sheets as a sample ? Thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>

  7. #7
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    sheet1's K2:K5 has same ID.. so which row you need here ? Thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>

  8. #8
    Registered User
    Join Date
    04-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    I need all the rows

  9. #9
    Registered User
    Join Date
    04-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    yes K2:K5 has the same ID and the line Total Value for them adds up to 492 see F2:F5 in sheet 1 and this is shown in sheet 2 document no 0000010122 in C2 total gross value of P2 sheet 2.

  10. #10
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    Okay.. so I manually updated all rows information from sheet1. Now how you would fill the grey cells from sheet2?

    Book2.xlsx

    Regards,
    DILIPandey
    <click on below * if this helps>

  11. #11
    Registered User
    Join Date
    04-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    I am a bit confused.
    I don't won't to manually fill the data.I am looking for excel formula which can do that for me.
    At least if a formula could be used to pull the document no column unto sheet 1 and link with the right data that will be great.
    regards
    krisuk

  12. #12
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    I don't won't to manually fill the data.I am looking for excel formula which can do that for me.
    I know this.. and just wanted to be sure what would be the final result look like after applying formulas and this is what I was expecting from you where you could have said "I have entered results manually and looking for formulas which can output same results" - hope you got the message


    Regards,
    DILIPandey
    <click on below * if this helps>

  13. #13
    Registered User
    Join Date
    04-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    Please find the completed file.
    Thanks
    Attached Files Attached Files

  14. #14
    Registered User
    Join Date
    04-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    I have manually completed it now.
    Thanks

  15. #15
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    Hi Krisuk,

    In sheet "aim to achieve this", paste the data in green cells from sheet 1 and drag down formulas in rest of the columns. thanks.
    Book2(2).xlsx


    Regards,
    DILIPandey
    <click on below * if this helps>

  16. #16
    Registered User
    Join Date
    04-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    Thank you Dilipandey.
    I will check this work life data tomorrow and let you know if it works ok.
    Thanks you for your wonderful job done.

    Regards

    Krisuk

  17. #17
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: pulling data from one sheet to another in a workdata which can be refreshed in excel.

    Okay... awaiting your reply



    Regards,
    DILIPandey
    <click on below * if this helps>

+ 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