+ Reply to Thread
Results 1 to 2 of 2

Opening a workbook based of off a cells value (multiple options to loop through)

  1. #1
    Registered User
    Join Date
    02-27-2017
    Location
    kent
    MS-Off Ver
    2007
    Posts
    41

    Opening a workbook based of off a cells value (multiple options to loop through)

    Hi I currently have a set of data like this

    Z AA
    1| file Path number
    2| location 1 1
    3| location 2 2
    4| location 3 1
    5| location 4 1
    6| location 5 2
    7| location 6 1
    8| location 7 2
    9| location 8 1

    there are loads more lines than this but this is for a demonstrative purpose there is also a sheet name in cell F2

    this table is in setupsheet,

    what I want to do is if the value in column AA is 1 i want to pull up the worksheet based off of the location (location 1, location 2 etc) in the form W:\everyone.......filename.xlsx

    go to a sheet in the newly opened workbook which will match the name in F2 in the first sheet copy a selected range (a6:q26) (F2 will change)

    then go back to the original workbook and copy it to a sheet named datasheet in the next available line,

    then repeat this for each of the rows where AA = 1

    I currently have this
    Please Login or Register  to view this content.
    send help please

    Kind Regards,

    T

  2. #2
    Registered User
    Join Date
    02-27-2017
    Location
    kent
    MS-Off Ver
    2007
    Posts
    41

    Re: Opening a workbook based of off a cells value (multiple options to loop through)

    z is the column with file path aa is the number column

+ 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] Macro Loop: Creating multiple workbook based on autofilter criteria
    By Carlo_02 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2016, 05:47 PM
  2. Upon opening workbook, loop over certain sheets and apply macro
    By jorjacman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2015, 11:36 AM
  3. [SOLVED] Copy particular columns from multiple workbook into one workbook without opening
    By abraham30 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2014, 05:16 PM
  4. [SOLVED] macro for searching multiple options with in workbook
    By vivek_work in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-03-2013, 02:58 AM
  5. opening workbook found with Dir loop
    By Willardio in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2013, 11:37 AM
  6. Multiple worksheets - opening options
    By Thess in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2007, 10:18 PM
  7. Loop through cells and add rows based on multiple criteria
    By Northern Hybrid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2005, 06:39 AM

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