![]() |
Creating a Calendar
I have a spreadsheet with a list of customers and information we require,
DOB, Address, etc. I want to have a calander where the name of the customer shows up on their appointment date. But I do not want to manualy enter the customers name on their appointment date on the calander (excel calander or outlook), I want to somehow from their information spreadsheet have the calander automatically updated the customer name on the day of appointment. |
Creating a Calendar
Why not just use the Outlook calendar? If you make the appointment in
Outlook, it'll show up on the calendar. "315539gsjm" wrote: I have a spreadsheet with a list of customers and information we require, DOB, Address, etc. I want to have a calander where the name of the customer shows up on their appointment date. But I do not want to manualy enter the customers name on their appointment date on the calander (excel calander or outlook), I want to somehow from their information spreadsheet have the calander automatically updated the customer name on the day of appointment. |
Creating a Calendar
Somewhere your going to have to create a link of some kind.
If A then get info at AA type of thing. I'd also like to see how something that is not related bet related outside of a data base. It could be as simple as putting a "date" on the info and having an excel form search the data row and when it "matches" date, return the info to that cell (referencing the cell info). "Duke Carey" wrote: Why not just use the Outlook calendar? If you make the appointment in Outlook, it'll show up on the calendar. "315539gsjm" wrote: I have a spreadsheet with a list of customers and information we require, DOB, Address, etc. I want to have a calander where the name of the customer shows up on their appointment date. But I do not want to manualy enter the customers name on their appointment date on the calander (excel calander or outlook), I want to somehow from their information spreadsheet have the calander automatically updated the customer name on the day of appointment. |
All times are GMT +1. The time now is 08:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com