Build a Summary

What I am trying to do:

1.) Have a macro/code loop through the work book and pull from the Summary at the bottom of the Shore Tank Reports and place the values onto a Summary page.

I found a macro that loops through all the tabs and pastes those totals to new summary page every time. What I want to be able to do is, have that Macro/Code loop through and pull the info only fromt the Shore Tank Reports tabs, and Update the Summary page, instead of deleting it everytime and creating a new one.

2.) Have a macro/code Pull the "Times, Date, and Events" from the Time Log tab and place that infomation on the Standard Wire tab also.

I would like to have this code autoformat the Events so that the (Proper) Caseing was implented and so that the Times, Date, and Events were in order from Oldest to Newest.

Please I really need some help on this, I am going nuts trying to make this work.

AttachmentSize
Blank-Inventory-Sample.xlsm481.05 KB
Vishesh's picture

A sample excel file would

A sample excel file would help in understanding your problem better.

Thanks for the Reply. Sorry

Thanks for the Reply. Sorry for some reason I couldn't get it to upload earlier. I appreaciate any help you can provide.