+ Reply to Thread
Results 1 to 1 of 1

VBA index, match, lookup or some combination of all?

  1. #1
    Registered User
    Join Date
    09-18-2015
    Location
    New York
    MS-Off Ver
    2013
    Posts
    31

    VBA index, match, lookup or some combination of all?

    Hello everyone,

    I have a rather unique project for excel I am working on. I am not the strongest VBA user, but I know what I'm looking for is possible (I think), just not well versed enough to write it.

    For the sake of simplifying what I am looking for, i created an analogy and associated workbook. I have a group of several hundred people listed in a table. First Name, Last Name, Age, Height, a Position, a number in that position, an X coordinate, and a Y coordinate.
    ~Each row item is unique
    ~All footage is in Decimal Format
    ~All measurements can be / are to the nearest inch
    ~2 sheets - First is Table, second is ruler.

    We are taking a group picture, but each person has to stand in a particular spot. The ruler is a 150' x 3" piece of paper that will be laid out at each position. The persons find their name and stand on one side or the other.

    VBA Concept: For each Row in Table, where "position" value is equal to the value of Sheets("Ruler").range("d6") match the X position in the table to the nearest X position on the ruler. The closest possible match. Merge the adjacent 8cells with 3 cells above and bellow (Resulting in 8 merged cells of 7 cells each). If the Y value is positive, return the other values of the table (First name, last name, age, height, number) starting in the last cell and flip text UP, if negative, start in the last cell and flip text DOWN.



    I've attached a sample workbook. Let me know if any of this is making sense. This may very well not be the best way to do this, but It's the best I've been able to come up with so far, and your help is very much appreciated. I've been up all night, so I'm looking forward to a morning of fresh ideas.

    Thanks,
    Attached Files Attached Files

+ 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] Index Match combination in VBA
    By Arnodekkers1995 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2017, 09:17 AM
  2. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  3. [SOLVED] Left Function in Combination with IF, LOOKUP, MATCH, or INDEX?
    By superwhoever in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-29-2012, 01:31 AM
  4. Combination of IF and INDEX/MATCH
    By flandophile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2012, 09:52 AM
  5. is this an index or combination with lookup
    By mheinmiller in forum Excel General
    Replies: 1
    Last Post: 12-16-2008, 04:20 PM
  6. Combination Lookup - Match - Index
    By idrisb59 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2008, 12:25 PM
  7. Replies: 2
    Last Post: 04-20-2007, 03:52 AM

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