+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP between worksheets

  1. #1
    Registered User
    Join Date
    11-08-2014
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    84

    Smile VLOOKUP between worksheets

    Hello members,
    I am trying to do VLOOKUP based on Date column. Before, I'm using a code to merge the files in a folder to a workbook, and then changing the structure of each worksheet by using a macro. However, I have still three remaining problems (VLOOKUP between worksheets) which I cannot do it by recording macro.
    Could you please help me accomplish it. I tried myself before to merge the codes but it was not successful.
    Thank you for the time.
    Attached Files Attached Files
    Last edited by Moriexcel; 12-20-2015 at 09:53 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: VLOOKUP between worksheets

    Have not opened your file/s, buy why the need to do vlookup with code? Wouldnt the standard function work better/simpler?
    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

  3. #3
    Registered User
    Join Date
    11-08-2014
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    84

    Re: VLOOKUP between worksheets

    I have 600 files and I have to group each 3-5 files in a folder based on some criteria. The manual grouping is time-consuming itself and I need to do the rest of things faster.

+ 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] vlookup on different worksheets
    By rjrcornelissen in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-18-2012, 07:05 AM
  2. Vlookup from 2 different worksheets
    By rakesh2806 in forum Excel General
    Replies: 4
    Last Post: 05-23-2012, 02:58 PM
  3. Vlookup across 12 worksheets
    By bobs1 in forum Excel General
    Replies: 5
    Last Post: 02-05-2010, 01:16 AM
  4. Vlookup across worksheets
    By manan.bansal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-06-2007, 10:08 AM
  5. Vlookup in different worksheets
    By ErwinR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-13-2005, 06:35 AM
  6. Vlookup over different worksheets
    By kwing in forum Excel General
    Replies: 5
    Last Post: 09-23-2005, 03:05 PM
  7. [SOLVED] Using vlookup on two worksheets
    By Steven Robilard in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-14-2005, 08:06 PM

Tags for this Thread

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