+ Reply to Thread
Results 1 to 14 of 14

Fetching data from another sheet

  1. #1
    Registered User
    Join Date
    08-04-2018
    Location
    Pune India
    MS-Off Ver
    2016
    Posts
    9

    Fetching data from another sheet

    In a workbook / file, one sheet named ‘summary’ contains some names in column A. The other sheets (e.g. ‘Test’) are named with the same name as contained in various rows in Column A of summary sheet. Now I want the values written in Test sheet to be automatically posted to Summary Sheet - Column B, Column C, etc. against the row in which Test is written in Column A. What may be the formula / function.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,857

    Re: Fetching data from another sheet

    You can do this with index match formula.
    Its better to share / attach sample file with desire result.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    08-04-2018
    Location
    Pune India
    MS-Off Ver
    2016
    Posts
    9

    Re: Fetching data from another sheet

    Summary sheet contains Column A at row 1 - alfa, row 2 - bravo, row 3 - Charlie
    alfa sheet contains A1 = The name, B2 = This is Alfa, A2 - Date of Birth, B2 - 01/01/1970
    Now in summary sheet in A1, if I write alfa, in B1 it should come automatically "This is Alfa" and in C1 it should come automatically "01/01/1970"
    So I will write summary sheet column A all rows manually, and I want functions / formula for summary sheet B1 & B2, which I can copy for all the rows in B1 and B2

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,067

    Re: Fetching data from another sheet

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    08-04-2018
    Location
    Pune India
    MS-Off Ver
    2016
    Posts
    9

    Re: Fetching data from another sheet

    Dummy File ready however, not able to see 'manage files' as suggested

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,067

    Re: Fetching data from another sheet

    Click Go Advanced, scroll down until you ATTACHMENTS, click Manage Attachments

  7. #7
    Registered User
    Join Date
    08-04-2018
    Location
    Pune India
    MS-Off Ver
    2016
    Posts
    9

    Re: Fetching data from another sheet

    file uploaded

  8. #8
    Registered User
    Join Date
    12-07-2012
    Location
    visakhapatnam
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Fetching data from another sheet

    How do I sort in this kind of order? It should be number then text. I made a column and inset numbers, texts, and even texts with numbers. It looks like this 1,2,3,4,5,a,b,c,d,e,1a,2a,3a,4a,1,b,2b... and so on. It needs to be like this, 1,1a,1ab,2,2a,2ab.

  9. #9
    Registered User
    Join Date
    12-07-2012
    Location
    visakhapatnam
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Fetching data from another sheet

    1
    1a
    1b
    1c
    2
    2a
    2b
    2c
    3

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,067

    Re: Fetching data from another sheet

    I dont see where you uploaded the file?

  11. #11
    Registered User
    Join Date
    08-04-2018
    Location
    Pune India
    MS-Off Ver
    2016
    Posts
    9

    Re: Fetching data from another sheet

    Check the file, if attached.
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    02-17-2011
    Location
    india
    MS-Off Ver
    Excel 2016 (home & student version)
    Posts
    49

    Re: Fetching data from another sheet

    Pls find the sheet attached.




    Once Query is resolved then make the thread as resolved.
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    08-04-2018
    Location
    Pune India
    MS-Off Ver
    2016
    Posts
    9

    Re: Fetching data from another sheet

    How about the date of birth column

  14. #14
    Registered User
    Join Date
    08-04-2018
    Location
    Pune India
    MS-Off Ver
    2016
    Posts
    9

    Re: Fetching data from another sheet

    Sir,

    Got it. Thanks a millions for the help and guidance.

    Regards,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Combinations and fetching in the Forms Sheet
    By fareedexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2017, 10:38 PM
  2. Replies: 2
    Last Post: 01-19-2017, 04:32 AM
  3. Replies: 4
    Last Post: 04-14-2014, 01:42 PM
  4. [SOLVED] Fetching average from another sheet.
    By Khoori7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-24-2013, 09:57 PM
  5. Replies: 0
    Last Post: 11-05-2013, 01:51 AM
  6. [SOLVED] Generate multiple invoices fetching data from rows of a sheet
    By devang.vakharia in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-12-2013, 08:14 AM
  7. Replies: 2
    Last Post: 02-04-2012, 12:00 PM

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