Excel formula or VBA code for extracting external file links

  • Hello

    I have an input sheet ( attached ). It contains two tabs ( Input 1 and Input 2). These have data for different years ( From 2011-2021) and different products ( A to G). Both of these tabs takes values from external excel sheets

    I need a VBA code to identify or create a list which contains tab name , the name of external sheet used and for which product and which year it is used . Please note that some of the products use more than one external file and I all the name that are used

    I have attached a sample output for the same . But I need a VBA code to do this as my original file has a lot more data.

    1. For example in the output sheet you can see for product A year 2011 file name is Dummy4.xlsx and similarly for product A year 2012.

    This is just a sample output . I need a VBA code that gives the full list along with year and product name.

    Thanks in advance



  • This is a duplicate post and as such does not comply with our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

  • royUK

    Closed the thread.