Hello,
I am fairly new to VBA and I think what I am attempting to do may be fairly complex. I have a workbook that has a "Project Info Page" where certain criteria are filled out and then a batch of log sheets are created from a hidden template with all common data filled in. There can be from 10 to 400 different logs by the end of a project. I then have a macro that pulls all data into a summary sheet for the enitre project. What I am currently trying to do is create a macro that will creat a "Daily Summary Sheet" that summarizes all logs that match the specific date entered into a box on the "Project Info Page". What I am running into trouble with is getting the macro to look at 2 different cells on all logs and if the date contained in either cell matches the date entered into the box on the info page, it will copy all of the relevant data from that page and summarize it, but also group the records in seperate sections based on one of the criteria contained in the logs(i.e. all records that have 8.5" in cell L14 will be grouped together, all records with 12" grouped together, etc.). The macros that I have in this book work but they are cobbled together from Google and recording and editing macros, so the code probably isn't very pretty. I have attached the workbook and another one that contains a summary that looks like what I am trying to achieve. Any help would be greatly appreciated!Piling%20Log%20and%20Summary%20Rev.1.xlsmDaily Pile Summary Example.xlsm