Please help me create a calender on Microsoft Excel using dates in the spreadsheet from another tab.
June 25, 2012 2:15 PM Subscribe
Please help me create a calender on Microsoft Excel as I can't find any help online.
posted by sockpim to Computers & Internet (3 answers total) 1 user marked this as a favorite
So.... I'm good enough with Microsoft Excel (2010 version I think) to be able to create good enough spreadsheets for work, tracking jobs and providing data and what not, but that's as far as I can go.
I currently have a master sheet, with hyperlinks of a customer's name, which takes me to each customers individual sheet. This sheet has a few dates on it that I need to have on the master sheet so I know when to book in customer visits.
I would love to be able to have it so that I can have these dates automatically show up on the master sheet or a calender that automatically updates itself/has a refresh function. Is there such a thing within Excel or something similar to this? If there is, could someone point me in the right direction or tell me how please.
Thanks in advance,