+ Reply to Thread
Results 1 to 2 of 2

Access another worktable with variable range

  1. #1
    Registered User
    Join Date
    11-23-2021
    Location
    Israel
    MS-Off Ver
    Office 365
    Posts
    1

    Access another worktable with variable range

    Hello, I'm trying to make things at work more productive, and for that I'm trying to make an excel file that will access another file in the same folder and bring me the values that we always use, not everything on file 2 is useful for us.

    So I have 2 excel file, file A is the one I'm working on, and file B is the one where the info is stored, and we receive it from a third party, File B always has the same layout, but different amount of info.
    I successfully made a formula to find the coordinates of the info I need(varies from file to file,so it's not a fixed position), but i can't make it work to retrieve the info in spill, only 1 value.

    I'm using index match to find the limit position of the table I'm looking for but since it match returns a number, I'm having trouble to make index return the values in between the limits.

    Thank you in advance.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Access another worktable with variable range

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Copy a range to a variable and restore the range from the variable
    By DonaldDukw in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-19-2020, 11:34 AM
  2. [SOLVED] Macro to select a variable cell range and copy it down a variable amount of times
    By JPoFresh in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-18-2019, 09:17 PM
  3. Copy variable range from variable workbook to variable range on current workbook
    By Locster79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2013, 10:37 AM
  4. [SOLVED] Copy/Paste Values from Variable Range to Corresponding Variable Range
    By Cpetersoc in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-14-2012, 08:20 AM
  5. [SOLVED] Passing variable to Access
    By Job in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2005, 11:05 AM
  6. How do I access a variable from another instance of excel?
    By Alan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-13-2005, 10:05 PM
  7. I Need VBA Assistance regarding passing a variable from Access
    By Brent E in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2005, 05: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