Generate weekly Report

Hi Guys

Please find attached the workbook "cheque". Currently it displays all the information for the date we select in sheet2 but what I want is when the user selects the week ending date then the report from Monday to Friday for the whole week should be printed off as attached example1 workbook.

Can anyone please solve my problem.

Thanks in advance for any help!!!

I started with an alternative for the report code:

Please Login or Register  to view this content.

After having done that it was relatively easy to implement your new criterion.

Please Login or Register  to view this content.

Wouldn't it be simpler to use a cell with validationlist to select a valid date ?
See the implementation in the attachment.

Hello Nancy123,

After looking at this problem, the big coding issue I found was with the formatting the date. While the approach I took is a bit more complex, it provides a greater deal of flexibility and ease of coding. The code creates new VBA object that tracks the amount and cheque count for each day of the week. The count tracking is done automatically within the object. The object also outputs the total amounts and total counts as 1-D arrays. You also have the option of returning the total sum or total count for all seven days. The macros below have been added to the attached workbook.

New VBA Object - clsDailySums

Please Login or Register  to view this content.

Weekly Report

Please Login or Register  to view this content.

NB. Aman1234 is the same person as Nancy 123 and asks the same questions using different aliases (maybe more aliases ?)

Your current answer is incongruent with your answer in the other thread:

Thank you so much for your reply.My old thread "Generate weekly report" was related to the application developed all in excel and then I changed the backing database to Access . Now in this thread I want to pull infromation from Access database and print out a report. Could you please guide me how to do this.

Anyway I am here for getting help from the expreienced Excel guys and I don't have any need to make any aliases.

I hope anyone can help me out of this problem.

If it's the same problem then don't duplicate tthe question, people will have the same opinion as snb & ignore them

Also, why rely on VBA all the time, a PivotTable would be a better way to produce reports

Actually Roy, I never used Pivot tables so don't know exactly how to start. Leith gave me the full solution to the problem and its working perfectly fine but now I changed the backing database to Access so don't know how to pull weekly information from Access database and print it out.

Thanks

I think anyone that can make that statement about PivotTables & works with data should be embarassed. I also strongly believe that before using VBA all inbuilt functions such be investigated first