• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help linking workbooks with changing names

S

Stephanie Arttus

New Member
So my problem is I am trying to link two workbooks but the worksheet name changes based on the week worth of data stored in it. I have one workbook that has a worksheet for every week of data for any given year. I have another workbook that is my report that pulls data for every week. I would like to link the two so I don't have to go a copy paste every week.

Is there a ways to do this?
 
No simple & clean way that I can think of...
  1. Is it possible to change the structure so that all of your data is on a single worksheet, rather than multiple? We could use several options to then split out the data into different weeks/months/years, but would be best if it was all in a single spot.
  2. Are macros/VB an option?
 
  1. No I don't think it will be possible to restructure the worksheet as it is a corporate form
  2. I would not be against macros/VB, however I am very inexperienced in them
 
You must log in or register to reply here.
Back
Top