+ Reply to Thread
Results 1 to 2 of 2

Find and Search Workbook based on Cell Range

Hybrid View

  1. #1
    Registered User
    Join Date
    06-09-2012
    Location
    toronto
    MS-Off Ver
    Excel 2003
    Posts
    1

    Find and Search Workbook based on Cell Range

    I hope this is a simple plea for help.

    Here is my situation:
    A folder filled with XML exported files and the number and name can vary - Done
    XML mapping for excel to import into premapped XML Schema - Done

    All xml files imported in one by one in a loop based - done
    So the worksheets that i imported the XML flies are name as of the "B1" value the file is called "FinalAOMTfr.xls"

    Now i have another file called worklog.xls, this file contains named individuals (listed under workbook FinaAOMTFR) starting from E1 F1 G1 .... and so on so forth .. underneath each heading has a list of tasks that are located in FinalAOMTfr.

    What i want to do is that run a macro that would compare the name in the worklog.xls with the B1 value in the FinaAOMTfr and then copy H3:H48 in FinaAOMTfr to the respective individuals name under the worklog E1 F1 G1... depending on the name.

    Im absolutely stuck and dont know how to loop and compare and copy.

    Anyhelp would be appreciated.

    Thank you

  2. #2
    Valued Forum Contributor AlvaroSiza's Avatar
    Join Date
    09-19-2007
    Location
    Staffordshire
    MS-Off Ver
    2007
    Posts
    591

    Re: Find and Search Workbook based on Cell Range

    Please post a sample workbook stripped of sensitive information.
    Perhaps it was the Noid who should have avoided me...
    If you are satisfied with my solution click the small star icon on the left. Thanks
    1. Make a copy of your workbook and run the following code on your copy (just in case)
    2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
    3. Paste the code from above into the empty white space. Close the VBE.
    4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".

+ 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