Calendar Generator in Excel

[Pigggy]

I want to prepare a Calendar where I just have to give the date range and it draws something suggested in the attachment.
I'm looking to prepare a consolidated data sheet.Sample.xls

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.



Then provide a better explanation of what you need.

[Pigggy]

I hope this helps...name changed, will ensure in future that it is more appropriate.

[zbor]

You mean like this:

[Pigggy]

You mean like this:

The date range will keep changing it can have 50 days also. So I'm looking for a dynamic solution so that I dont have to draw such kind of sheets again and again.

[royUK]

That title seems no better to me, the question is more about summarising data

[zbor]

Roy, now I'm not sure it's about summing data..
Here is generating table...

Can't sum them after generating because (I assume) first need to add data

Change dates and click generate button

[Pigggy]

it's good to go - I've saved the file on my c:\

Now, how I can import day on day data into this file.

I've a seperate report for each day on C:\drive itself from where I wanna to import data (The file name has name like - DPR 02/01/2012, DPR 02/02/2012 and so on.

Lets say - if I'm preparing this file on 2nd Feb 12 - it should have data of first two days. - likewise, with each going day - I wanna to import data.

[zbor]

If some date, for example 15.3.2012 have always same values you can put them in 2nd sheet and call them with VLOOKUP formula in this sheet.

[Pigggy]

I was looking for a macro that will automatically import data from the daily report based on the date mentioned in Col A of the file supplied by you

[Pigggy]

@zbor - any suggestions?

[Pigggy]

Importing data?