+ Reply to Thread
Results 1 to 3 of 3

Lookup offset index match or VBA

  1. #1
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Lookup offset index match or VBA

    Hi Guys,

    I am looking for a solution to an issue.

    I have uploaded a sample workbook which shows the desired output (much easier than explaining) however, here is a brief explanation of the issue

    At any time of the month I export the data seen in A1:B83 from one of our systems.

    Col B figures are "Actual" figures which should populate the Actual rows in the Drill Down Tab

    I am looking for a quick efficient way of copying the data to the correct position in the Drill Down Tab

    Currently I have to copy and paste special transpose values from the range B2:B83 into various ranges in the Drill Down tab.

    eg B2:B13 gets transposed to Drill Down range E10:P10
    B16:B27 gets transposed to Drill Down range D20:O20 and so on... some products may not have data for some months eg Water & waste treatment currently has no data for May

    I have to do this for all 6 products (highlighted in blue)

    Can anyone recommend a way of achieving this using a formula or code?

    Many thanks for you time
    Attached Files Attached Files
    Last edited by Blake 7; 02-18-2014 at 07:43 PM.
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Lookup offset index match or VBA

    There is a button on sheet source.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Lookup offset index match or VBA

    hi ab, many thanks, just what i was looking for.... you have really helped me out. Now to learn how it was done!!

+ 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. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  2. Index match offset to get subsequent index values in a column
    By Andrew_Step in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2013, 02:55 PM
  3. Replies: 2
    Last Post: 12-10-2010, 11:39 AM
  4. MATCH, LOOKUP, OFFSET, INDEX,...or what??
    By HuskerBronco in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-06-2006, 09:40 PM
  5. lookup, index, match, offset, etc.
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2005, 05:50 PM

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