Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to set up a devilery schedule calendar from excel database

I have a large excel database and need to put it into a monthly calendar
format that is representive to a delivery schedule. Each delivery needs to
be pulled into the correct date and include mutli other fields from the
original excel database
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 140
Default How to set up a devilery schedule calendar from excel database

I'm not sure what you mean "a monthly calendar format". Is that a set of large boxes(7 columns x 5 weeks) with a month name on it?

Or can it be like;
Column A Column B Column C Column D ...
Row 1 Wednesday, Aug. 13 1997 thing 1 thing 2 thing 3
Row 2 Thursday, Aug. 14 1997 thing 1 thing 2 thing 3
Row 3 Friday, Aug. 13 1997 thing 1 thing 2 thing 3
....

Dennis


"KKL 2009" <KKL wrote in message ...
I have a large excel database and need to put it into a monthly calendar
format that is representive to a delivery schedule. Each delivery needs to
be pulled into the correct date and include mutli other fields from the
original excel database

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default How to set up a devilery schedule calendar from excel database

On May 2, 11:28*pm, KKL 2009 <KKL
wrote:
I have a large excel database and need to put it into a monthly calendar
format that is representive to a delivery schedule. *Each delivery needs to
be pulled into the correct date and include mutli other fields from the
original excel database


I would recommend importing the data into MS Outlook Calendar or
Google Google.
They both support a Excel CSV type input. Search CSV Outlook/Google
Calendar import for more info.
From there you can print & use the available Outlook/Google Calendar
features.

If you want the calendar to be in native Excel format you can then use
a 3rd party tool called WinCalendar to render your Outlook or google
Calendar into a fully formatted Calendar in native Excel format.

Regards
Mike
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
View excel schedule data in calendar format jkempen Excel Discussion (Misc queries) 0 November 4th 08 02:45 AM
calendar/schedule sjkostr Excel Worksheet Functions 1 November 27th 07 05:23 PM
monthly work schedule for 2 people on same calendar roadbitch Excel Discussion (Misc queries) 0 May 18th 06 01:17 PM
How can I create a calendar from excel data (schedule)? Shelly K Excel Discussion (Misc queries) 0 January 11th 06 08:55 PM
Export/link a course schedule from excel into calendar format kza40381 Excel Discussion (Misc queries) 0 June 29th 05 08:19 PM


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"