Creating Summary Sheet From Multiple Sheets

Saw that this thread might be able to help me out with a summary sheet that I am trying to create, but as I am new programing in excel not sure if it is actually what I need to use to accomplish my goal. This is what I am trying to accomplish, I have a work book with 7 worksheets that represent the days of the week and then want to transfer that inforamtion into a summary. I have included my workbook, everything in green has to be transferred into the summary. The rows under each section may expand to have to allow for more data to entered I woul d think a count command have to be used to transfer data until finds a blank cell. Any help or suggestions would be great.

http://www.excelforum.com/excel-prog...e-columns.html

Hi jdwoods,

I'd keep all your data in a single table and then filter and sort to show what you want.
I'd add a column for Container Type (20 Ft, 40 Ft etc)
If it were in a single table the Totals would pop out with a simple pivot table and the Month End Summary would also be easy. Tables were called Lists back in 2003 Excel.

Hi Jamie

I'd like you to put some data into the various categories "20 FOOT CONTAINERS", 40 FOOT CONTAINERS", "INTERMODALS" etc for at LEAST two days (preferably more) then carry this information over to the "Month End Summary Sheet" so I can "SEE" what you're looking for.

I'm not at all certain how we get a monthly summary from only seven days of data but that's as issue we can later explore together (are you using 4,4,5?)

Hello jdwoods,

I added random data to your workbook to test this macro and from what I did it appears to be correct. You will need to test this to be sure it is correct. Run the the test on a copy of the original workbook to prevent any possible data corruption. Add this macro to a separate VBA module in your workbook's VBA project. You can run the macro using Alt+F8 keys to bring up the Run Macro dialog.

Please Login or Register  to view this content.

Hello jdwoods,

To update an end of the month summary as data is entered does not fit with a the definition of a summary report. A summary report is collection of data that been entered and verified for a particular period of time. What you are describing is real time inventory tracking program, which is quite different from a summary report and more complex. Which of these do you really need?

Hello jdwoods,

I have set the macro to run anytime the contents of any cell is changed on the daily worksheets. Given your current need for simplicity, this is probably the best option. This will ensure the data is always up to date.

I apologise if my previous post was abrupt. Knowing your situation now, makes sense why you want to it this way. It seemed odd to update constantly if you were the only one in charge of the summary report. The attached workbook has all the new changes made.