I am currently using Excel 2007
I have a second tab called Calendar. I can select the month Jan 2015 to Dec 2015. Cell AK35 = WD, Cell AL35 = Day and Cell AM35 = Date
In the first tab that gets distributed Cell A3 = Date, B3 = Day and C3 = WD
I would like A3 and B3 to reflect what is in the Calendar tab and if I also change C3 (WD) manually it will pick up the relevant data from Calendar tab
I hope this is clear.
9 freelance font une offre moyenne de £19 pour ce travail
I would like to see your file but I think that I can help you . Indeed I thinks that the ,os important is how you choose the date in your second tab. Greetings