add data into a calandar sheet

Hello, only new to this forum so appologies if this is in the wrong place

I have a workbook that I have created with data in one sheet and I have created another sheet with a calendar in it. now comes the difficulty well for me anyway
n Worksheet 1 (Named "info 1") this contains the following:
Column A is date in dd/mmm/yyyy format
Column C is Day of the week in DDD format
Column D is the name of the person
Column E is the Address of the person
Column F is the time in 12hr format (9:00am)
Column H is the attendance format (Weekly, Fortnight, Monthly..........Etc)

I would like this information to auto fill the calendar sheet:

Sheet name is "Cal Jan 2014"
in A3 to C3 is Monday
in D3 to F3 is Tuesday
In G3 to I3 is Wednesday
In J3 to L3 is Thursday
In M3 to O3 is Friday

Then

In A10 to C10 is Monday
and So on

Now what I would like is the info from "sheet 1" where the date is equal to the date in the calendar take the info from "sheet 1" and place it into the appropriate cell in the calendar.

Hmmmmmmmmm hope this makes sense?

Is this at all possible?

Thank you
Chris

Hi Chris

Welcome to the forum (and indeed 2014 !)

Yes it is do-able.

A few questions:
1 - How do you want to handle the situation where there are 2 instances on a given day in "info 1" (or is that not going to happen?)
2 - Do you want all 6 headings from "info 1" to appear in the calendar (if so, how are you going to fit it in to A3 -c3 ) (you see why we ask for samples to be posted!)
3 - Are you expecting the information to be repeated Weekly, Fortnight, Monthly..........Etc (in which case a stop date will be required in "info 1") (Never tried this before - could be quite challenging )

Let me know what you want and I will see what can be done.

Regards
Alastair

Hi Chris

A further question

How do you wish to handle months? For example 31 Mar 2014 is a Monday. Do you want 1 April 2014 to be on the same sheet or does it need to be on a new sheet (called, unsurprisingly "Apr 2014"), or will 31 March 2014 be on the April sheet?

Regards
Alastair

Originally Posted by aydeegee

Hi Chris

Welcome to the forum (and indeed 2014 !)

Yes it is do-able.

A few questions:
1 - How do you want to handle the situation where there are 2 instances on a given day in "info 1" (or is that not going to happen?)
2 - Do you want all 6 headings from "info 1" to appear in the calendar (if so, how are you going to fit it in to A3 -c3 ) (you see why we ask for samples to be posted!)
3 - Are you expecting the information to be repeated Weekly, Fortnight, Monthly..........Etc (in which case a stop date will be required in "info 1") (Never tried this before - could be quite challenging )

Let me know what you want and I will see what can be done.

Regards
Alastair

Thanks Alastair,
There will be multipule entries in a given day but different people and addresses
In some instances depending on weekly, fortnightly and monthly it needs then to populate accordingly
Not sure how to copy and paste sheet but here goes
Top Part is the calendar second set of data is how t is in the Info1

Dec 2013 - SUN-29 Jan-14
Dec 2013 -Mon-30 Dec 2013-Tue-31 Wed-1 Thu-2 Fri-3
Scotchmer St Union St
10:30am test person 9:00am test3
Gadd St Kookaburra Walk
11:30am trest 2 11:30am test4
Hickford St
9:00am Sally
SAT-4 SUN-5
Mon-6 Tue-7 Wed-8 Thu-9 Fri-10





SAT-11 SUN-12
Mon-13 Tue-14 Wed-15 Thu-16 Fri-17





SAT-18 SUN-19


Mon-20 Tue-21 Wed-22 Thu-23 Fri-24






SAT-25 SUN-26


Mon-27 Tue-28 Wed-29 Thu-30 Fri-31




SAT-1 SUN-2 Feb-14
Mon-3 Tue-4 Wed-5 Thu-6 Fri-7





SAT-8 SUN-9
Mon-10 Tue-11 Wed-12 Thu-13 Fri-14





SAT-15 SUN-16
Mon-17 Tue-18 Wed-19 Thu-20 Fri-21





SAT-22 SUN-23


Mon-24 Tue-25 Wed-26 Thu-27 Fri-28







B C D E F G H
date Day Start time Client Name Address ABN/ACN as applicable Income/Service Type
1 1/01/2014
2 2/01/2014 Thu 10:00am Maureen Daley River St, Fortnight Clean
3 3/01/2014 Fri 9:30am Susan Marshallsea Ryan St Fortnight Clean
4 Fri 11:30am Tony/Liz Kookabarra Way Weekly Clean
5 Quote Fri 6:00pm Melinda Allambee Av Quote
6 4/01/2014 Sat
7 5/01/2014 Sun
8 6/01/2014 Mon 10:30am Danielle/Jason Scotchmer St Weekly Clean
9 Mon 12:30pm Ellen Ruse St Fortnight Clean
10 7/01/2014 Tue 11:30am Tony/Liz Kookabarra Way Weekly Clean
11 Tue 9:00am Jessica Union St Weekly Clean
12 8/01/2014 Wed
13 9/01/2014 Thu
14 10/01/2014 Fri 11:30am Tony/Liz Kookabarra Way Weekly Clean
15 Fri Melinda Allenbee St Exit Clean
16 Fri Melinda Allenbee St Window Clean

I have done lots of calendars like this. Post an example file with a small amount of data in it, and indicate manually how you want the data to appear in the calendar sheet.

Pete

Hi Chris

It is not good practice to copy whole replies - it just wastes space!

The items that you have copied do not really help as I cannot envisage exactly what you are looking for.

It will probably be best if you load up some sample sheets (as suggested by Pete) and then go with his expertise!

Regards
Alastair

Sorry not certain if you do or don't reply with other message but now I know, thanks for the information.
Below is a pic of the data and calendar. the first section is manual data entry and the second is the Calendar with the data entered.
Each month is separate from each other and information can change and be added.
test calendar data.jpg

Hope this helps
Regards
Chris

Chris,

a picture is not much use - attach an Excel workbook instead.

Pete