+ Reply to Thread
Results 1 to 11 of 11

Populate Output sheet based on input data and lookup condition

  1. 07-03-2013, 09:19 AM #1
    Cool\m/
    Cool\m/ is offline
    Registered User
    Join Date
    05-08-2013
    Location
    In your gf's house
    MS-Off Ver
    Excel 2010
    Posts
    16

    Populate Output sheet based on input data and lookup condition

    Hi,

    I want to write a macro which will populate the 3rd sheet, that is Output, from the sheet named 'Input'. And it will search which data will go which column based on the sheet name 'lookup'.

    For example, in the attached file , it will search in lookup file that in Output sheet, Column(A) 'Name' will be populated from Input sheet's Column(A). Output sheet's Column(F) FirstName will be populated from Input sheet's column(A) Name. and so on

    I have attached only the basic ersion of the sheet. The original one contain more columns and more conditions.

    Please help me on this. I am not able to find any clue to write a macro for this.


    The main goal is to populate data from Input sheet to Outpur sheet based on the lookup data.

    Regards,
    cool
    Last edited by Cool\m/; 07-10-2013 at 04:03 AM.
    Reply With QuoteRegister To Reply
  2. 07-04-2013, 12:54 AM #2
    Cool\m/
    Cool\m/ is offline
    Registered User
    Join Date
    05-08-2013
    Location
    In your gf's house
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Populate Output sheet based on input data and lookup condition

    bump...!!!
    Reply With QuoteRegister To Reply
  3. 07-04-2013, 05:57 AM #3
    Cool\m/
    Cool\m/ is offline
    Registered User
    Join Date
    05-08-2013
    Location
    In your gf's house
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Populate Output sheet based on input data and lookup condition

    bump again
    Reply With QuoteRegister To Reply
  4. 07-04-2013, 09:19 AM #4
    Cool\m/
    Cool\m/ is offline
    Registered User
    Join Date
    05-08-2013
    Location
    In your gf's house
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Populate Output sheet based on input data and lookup condition

    Bumping again, I need it as urgent. If anyone can, please help me.
    Reply With QuoteRegister To Reply
  5. 07-05-2013, 03:00 AM #5
    Cool\m/
    Cool\m/ is offline
    Registered User
    Join Date
    05-08-2013
    Location
    In your gf's house
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Populate Output sheet based on input data and lookup condition

    Bumping again..!!
    Reply With QuoteRegister To Reply
  6. 07-08-2013, 08:01 AM #6
    Cool\m/
    Cool\m/ is offline
    Registered User
    Join Date
    05-08-2013
    Location
    In your gf's house
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Populate Output sheet based on input data and lookup condition

    Reply With QuoteRegister To Reply
  7. 07-10-2013, 03:57 AM #7
    Cool\m/
    Cool\m/ is offline
    Registered User
    Join Date
    05-08-2013
    Location
    In your gf's house
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Populate Output sheet based on input data and lookup condition

    LOL What kind of forum is this? 1 week past but still no reply.
    Is everybody noob here? Or nobody cares? All are money beggers. Pay me and I will solve. Is this is the mentality? Then what is the need of online forums?

    I pmed some moderators also, even they also did not care to reply at least. Even if you all are noobest to solve this issue, atleast a reply could do much better.

    But sadly either you all are after money or dont even have a little manners.
    Reply With QuoteRegister To Reply
  8. 07-10-2013, 04:08 AM #8
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Populate Output sheet based on input data and lookup condition

    $10 is not lots of money.
    Think rationally:
    You have bumped the thread for over a week; I am sure you had spent lots of time trying to find a solution. Even $50 is a price of a latte in Starbucks nowadays.

    You would have saved lots of time and money if you had posted it on the fee section. The section will find you a solution as you have paid for it.
    Reply With QuoteRegister To Reply
  9. 07-10-2013, 04:40 AM #9
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Populate Output sheet based on input data and lookup condition

    Cool,

    Did you check to see if your 1st post has any info missing? You say you have attached the file but i dont see any. Before blaming the forum members, check once again if your post has enough explanation which can prompt others to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  10. 07-10-2013, 04:41 AM #10
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,411

    Re: Populate Output sheet based on input data and lookup condition

    Also, you refer to an attached file in your first post, but you haven't attached a file - the FAQ describes how to.

    Pete
    Reply With QuoteRegister To Reply
  11. 07-10-2013, 04:45 AM #11
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Populate Output sheet based on input data and lookup condition

    I have seen an attached sample with that thread.
    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