Create a summary sheet

**excel-with-excel** · 04-23-2010, 12:14 PM

Ok, I have created a workbook at work. It contains lots of worksheets within it, each worksheet being a seperate job number.

So what I would like to do is, create one worksheet that has a "live" summary of each job.
So, if needs be, I just open up this workbook, go to my 'Summary' page and I can quickly look at the status of the job from there. So.. I have the exact idea of what I want, I know that every job number (worksheet) has to feed into this one paticular worksheet (Summary).

So for example, if I was to go to job number 3 and changed its status to 'complete', this would then change it automatically on the summary sheet!

I know it's quite complicated, especially when I already have macros and everything in which I have created (this is for when I open a new job, I press my shortcut keys and it automatically opens a worksheet and completes all the form formatting for me.)

If anyone has any suggestions (in layman's terms!

) please reply to this post.
I'd be very happy to hear any suggestion what-so-ever!!

Thanks!

P.S. Please see attachment to see my rough draft diagram

**JBeaucaire** · 04-23-2010, 12:37 PM

As this is programming forum I presume you're looking for a macro to create the summary for you. It's pretty simple to run through all the worksheets in a workbook grabbing values from the same cells and putting them in same columns on a Summary. All we need is a clear template to write it from.

The PDF is no help. Click GO ADVANCED and use the paperclip icon to post up a sample workbook. Make sure the sample workbook contains a few of those worksheets and your summary is already laid out with the answer inserted from those few sheets. That should be enough to see where the data is coming from. If not, highlight it.

That should be enough to craft a quick macro for you.

**davegugg** · 04-23-2010, 12:39 PM

My suggestion is to use Access. A relational database keeps track of these things up to date, and you should need very little VBA to have it work well. Plus it is much easier to create forms and reports that will look how you want them to without relying on VBA. For examples and tutorials, check microsoft's web site.
http://office.microsoft.com/en-us/training/default.aspx

**royUK** · 04-23-2010, 01:03 PM

Seems a bit pointless asking for Excel help & attaching a pdf,a workbook would be more appropriate.

I would use an excel sheet as a data store set uop in a proper table format, then summarise with a Pivottable

**excel-with-excel** · 04-26-2010, 10:28 AM

Originally Posted by royUK

Seems a bit pointless asking for Excel help & attaching a pdf,a workbook would be more appropriate.

I would use an excel sheet as a data store set uop in a proper table format, then summarise with a Pivottable

You know, RoyUk, you are one of the majority on this forum I see. Very pompus and arrogant. Get a life. If you can't be of help, don't post on my thread!

Thanks to the other people that replied, your advice is very good and I will reply shortly.

I've had nothing but arrogance from people on this site since I joined, so your informative replies were a breath of fresh air!

**JBeaucaire** · 04-26-2010, 10:47 AM

I would have been more than happy to write a macro for you to help solve your problem.

The response you gave to Roy above was completely inappropriate. I'm done here unless I see some sincere apologizing next.

**excel-with-excel** · 04-26-2010, 10:50 AM

Originally Posted by JBeaucaire

I would have been more than happy to write a macro for you to help solve your problem.

The response you gave to Roy above was completely inappropriate. I'm done here unless I see some sincere apologizing next.

Clearly you do not know the way I've been spoken to on here since I joined only days ago? I just wanted a bit of help and guidance. Instead, I've been treated as though I am an imbocile.

**JBeaucaire** · 04-26-2010, 12:27 PM

Ok. Sorry you're feelings are hurt. That's clearly the most important thing here, so I guess we're done. Your call. Unfortunate, though understandable. (it's a tough group here, but well worth it for the help you get).