Trying to display information from multiple sheets onto 1 summary sheet.

Hi,

Can somebody offer me advice as to what formula is best to use to summarize information detailed within multiple sheets/tabs and then for it to be filtered/displayed in date order?

Please see attached for further details.

Thanks in advance.

Do you want the information to go from the summary to the other tabs or from the other tabs to the summary? The question seems to be the former whereas the spreadsheet question is the latter.

Apologies I would like information from the summary sheet to then be displayed in the correct month tab using the "start date" column as a reference point.

Hi, it would appear I haven't made myself very clear.

I would like to come up with a formula that looks at all of the information on my summary sheet and then for that information to automatically populate the same information into the relevant monthly tabs (it should do this by searching the start date).

I have included the file again so that it is a little clearer to understand.

Any help would be appreciated.
Thanks

So, are you saying that you enter data into the summary sheet, and that you want the data to populate the monthly sheets automatically, based on the Finish Date in the Summary sheet?

Two other things - you don't have a sheet for Oct 2012, and the November sheet is named Nov 12 rather than Nov 2012 (like the others).

Pete

The attached workbook does what you are after. I have added two columns of formulae in columns P and Q of the Summary sheet, copied beyond your data (copy further if you require more for your real data).

Each monthly sheet is now purely formula-driven, and will pick up data automatically from the Summary sheet depending on the month of the Start Date. The formulae are copied down to row 10 in each sheet - just copy them further if you have more data. I've retained what you had typed in these sheets before, for comparison.

Hope this helps.

Pete

Thanks again Pete, really appreciate the time and effort you have gone to over this.

Okay, well if you are happy with that perhaps you can mark the thread as Solved, and to express your thanks further you can also click on the "star" icon at the bottom of any post that was helpful to you. Same applies to your other thread.

Pete