Hello and thank you for contacting JustAnswer, a paid expert support site. My name is Brandon and I'd be glad to assist you with your issue.
What you should be able to do is import that spreadsheet directly into Outlook. When you import the file, it will ask you to map fields which you should be able to do if I am understanding the layout correctly.
This does not work. The way that I need to see it is the project name(row) & date type(column). That was the first thing that I tried to do
Maybe I could understand better if I saw the spreadsheet - Can you send a sample to me? Easiest way is to upload it to http://www.wikisend.com/ and give me the File ID after you have done it.
Ideally, the outlook calendar would be updated when the project list is.
ok...give me a few
That wouldn't be possible unless you had a shared calendar ON sharepoint
Great- give me a little bit to look this over and do some testing.
Ok, so which date is to be used on the Calendar and where is the project name? I see customer and a product name.
project name is the customer name
all dates...that's what is causing the issue. I would like to get specific dates to populate in a calendar with the project name and type of date.
e.g.-- on 3/2/12 I want it to show the project name and what column--projected live, projected install, wiring, etc...
does that make sense?
Ok, so you want an entry for the requested date, an entry for the installed date, an entry for the projected date, etc, correct?
yes...on a calendar with the project name. that's the key here...I need to look at a calendar on 3/5/12 and see "customer1-wiring", "customer2-install", "customer3-equipment eta", etc...
Ah, ok. That is a little over my head, sorry.
I don't care if I have to have multiple excel tabs with hlookups, vlookups, etc...i just want it to work
I understand what you are looking for but I don't know how easy that can be done without some serious editing of the excel before importing each time.
I will opt out and allow another expert to look at this.
Ok, is this really that complicated? thanks for your help. will i have to go through this chat again?
When another expert picks it up, it will switch to a Q&A (forum) style posting.
It sounds complicated to me but another expert with macro knowledge might be better at this.
No problem. Have a nice evenig.