I am looking to take a data set and create a table that is summarized down according to a begining date and ending data. I have attached a file that shows what I am looking for.
Thanks
I am looking to take a data set and create a table that is summarized down according to a begining date and ending data. I have attached a file that shows what I am looking for.
Thanks
Hello RTM1,
I have added the macro below to the attached workbook. The macro runs after the end date has been entered.
Macro Code
Please Login or Register to view this content.
'Result' Worksheet Change Event Code
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks for the help!!!!!
I was testing the code and have found that if you have two records that match the end date it will only populate the first. Is there a way i can fix this so that all records on the end date are included? Thanks for your help
Hello RTM1,
Here is the amended macro. I added a loop to check if EndDate is the last one. This macro will work correctly as long as all the dates are in ascending order. The attached workbook has the macro added.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks