Hi!

I’m having some trouble with a project for work.

I have about 60 individual sheets of service. They all have a recap of all the hours spent by locations per month. I would need to have a report for all of them to reverse and have the total amount of hours spent by locations, not nominative.

Is there something, either only with excel or via access that can "cumulate" all the "recaps" into one table/sheet?

Sorry if it isn’t clear!

Thanks!

not to be mean, but the explanation here only calls for you uploading the file so people can see what you're talking about. it's impossible to give advice about consolidation like this because the possibilities are endless, and the situations are also endless.

Well I guess you'd have to have all your sheets in one table before Acecss can do much in terms of summing hours etc.

Try appending all your sheets together (just using the import wizard), then you could just do a quick query - group by location, and sum the hours.

YES!!! Append, thanks!! i knew something like that was possible, i just couldn't find the name! From there, i can make my reports, thank you!!!

and sorry, i should have put more info on my files, not used to go on forums to find tips and help.

Good luck! This forum is great, I bet you'll be back again before long....