Forum Discussion

Deleted's avatar
Deleted
Not applicable
May 23, 2018

Link 2 excel workbooks

I'm trying to setup a workbook to automatically pull data from another workbook, I only want certain columns. I would like 5 workbooks setup the same way called Monday, Tuesday, Wednesday.. Firday. Every week a new workbook will be created that includes all days but would like the specific workbook for that day to pull the data from certain rows.

excel

2 Replies

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 31, 2018

    Fatih-

     

    I just wanted to follow up and see if your issue was resolved or if you still needed additional help.  Please don't hesitate to reach out if you have questions or need clarification.

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 23, 2018

    Faith-

     

    There are several different approaches to accomplishing your end result.  I have attached an example file that contains two methods (Please see attached). :

     

    1. Dynamic Column pull using Vlookup()

    2. Dynamic Column pull using Offset()

     

    Here is how the data is set up:

     


    Both of these example also use the weekday function and the today function.

     

    Please see additional information regarding these functions here:

     

    https://support.office.com/en-us/article/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9

    https://support.office.com/en-us/article/weekday-function-60e44483-2ed1-439f-8bd0-e404c190949a