+ Reply to Thread
Results 1 to 9 of 9

Retrieve data from other sheet

  1. 12-23-2011, 09:07 AM #1
    nvsanilkumar is offline
    Registered User
    Join Date
    09-14-2011
    Location
    Vizag
    MS-Off Ver
    Excel 2003
    Posts
    16

    Retrieve data from other sheet

    Sir

    In the enclosed sheet. Sheet 1 has work order numbers. In the Sheet 2 I need to match the work order number and retrieve products departments and in charge names to sheet 1

    Please help.

    Thanks
    Anil
    Attached Files Attached Files
    Last edited by nvsanilkumar; 12-23-2011 at 09:25 AM.
    Reply With QuoteRegister To Reply
  2. 12-23-2011, 09:20 AM #2
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Retrieve data from other sheet

    What enclosed sheet do you speak of?
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files
    Reply With QuoteRegister To Reply
  3. 12-23-2011, 09:21 AM #3
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Retrieve data from other sheet

    There seems to be a problem with your attachment, it was returning an invalid link, now it's dissapeared altogether!
    Reply With QuoteRegister To Reply
  4. 12-23-2011, 10:38 AM #4
    Alf is offline
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Retrieve data from other sheet

    Perhaps like this?

    Alf
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 12-23-2011, 11:15 AM #5
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Retrieve data from other sheet

    @ Alf
    You could take your idea a step further and make the name "Data" dynamic, to allow the table to grow/shrink as required.
    See this attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 12-23-2011, 12:36 PM #6
    Alf is offline
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Retrieve data from other sheet

    Hi Marcol

    Excellent idea! Let's hope the OP appreciates it. At least I do and I'll save it in my file of Excel tips and tricks!

    Regards

    Alf
    Reply With QuoteRegister To Reply
  7. 12-23-2011, 01:35 PM #7
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Retrieve data from other sheet

    @ Alf
    If you are keeping the file for reference then it might be useful to add these notes

    1/. For lists that are text only use this
    e.g.
    Please Login or Register  to view this content.
    2/. For lists that are numbers only use this 
    Please Login or Register  to view this content.
    3/. For lists that are both text and numbers only use this 
    Please Login or Register  to view this content.
    4/. For lists that could possibly be either text or numbers only use this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 12-23-2011, 02:54 PM #8
    Alf is offline
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Retrieve data from other sheet

    Thanks again Marcol

    I'm really impressed! I do collect this kind of valuable tips and tricks and add it to my "excel help" doc file, at moment this file is 196 pages long.

    Alf
    Reply With QuoteRegister To Reply
  9. 12-27-2011, 07:43 AM #9
    nvsanilkumar is offline
    Registered User
    Join Date
    09-14-2011
    Location
    Vizag
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Retrieve data from other sheet

    Dear All

    Thanks for all your support.

    Regards
    anil
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1