Hi everyone,
I'm relatively new to the Excel world and have learning formulas on the fly - made timesheets to pull data from calendars I've made but as I started uploading everything to SharePoint and fixing all the links, I realized that I had forgotten to ensure the data pulled is not only for one month but all 12.
I haven't a clue how to even begin with using the indirect function to be able to search from all 12 worksheets. See attached images.
Current formula pulling for just the month of May into row 9 of Timesheets:
=INDEX([OT_Calendar.xlsx]May!$B$4:$AI$75,MATCH($A$9,[OT_Calendar.xlsx]May!$B$4:$B$75,0),MATCH(C$8,[OT_Calendar.xlsx]May!$B$4:$AI$4,0))
Any ideas would be much appreciated!
Cheers,
Win
Bookmarks