I have a spreadsheet for a team of agents stats, the front page has agents along the top and stats down the left hand side. Each subsequent tab has that agents stats down the side and each column is the progressing weeks and a tab for the team which collates the agents info in to team figures...at the moment the front page displays the info for the first week for each tab...I want the info displayed on the front page to change the information it displays as the weeks progress, so in week 1 it'll display each tab column B, then at the start of Week 2 it'll change to display each tab column C and so forth...How do I do this??? Would it be a macro and if so how would I write it??? Or would it be linked to the current date/time function with a formula???
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!