Sum different columns from multiple worksheets..multi variable

[berbchid]

OK... so I have ten worksheets with various names (i.e. office, welders, drivers, etc). Each has a list of different tickets /requirements, and their expiry dates. I have each column's expiry dates counted and summed up across the top (i.e expiring in 30 days, 60 days). Some of the columns are universal to all the sheets, like 'drivers licence'... but this is not always in the same column (may be D in 'office', but G in 'welders').

What can I write (probably in VBA) that can search out all the 'drivers expiry' across all the sheets, and sum it up?
I know this is going to be multi-stage, with something to find the text string, then an offset to find the appropriate results cell, return that value, repeat across the worksheets, then sum all the returned values. I'm just struggling with the syntax of this , so any help would be much appreciated.

[stnkynts]

Can you submit a copy of your workbook?

[berbchid]

I can upload the template sheet, that is then adjusted depending on the group... some of the columns are removed depending on what each group needs. The actual book has 10 of these, not all having the same columns. What I need is a way to sum up the expiry information for each column that expires, across all the sheets.

templatetickettracker.xlsm

[stnkynts]

Issues:

1. It would help if you actually submitted some artificial data with your workbook. Not just a blank template.

2. Your template sheet is set to have dates in the "Drivers Abstract Expiry" section (which is the section I think you want summed). How do you sum dates?

3. Where do you want to "sum it up" at?

Keep in mind that I know nothing about your sheet so things that make sense to you, will not make sense to me.

[berbchid]

Ok.. here's an filled in version of the template, with the stats page at the beginning, 'start' and 'end' sheets are hidden. It's the numbers above the column headings that I need to sum up, across the sheets, for each heading.

templatetickettracker.xlsm

[stnkynts]

Your second attachment does not have anything filled in, nor are there hidden sheets, like you indicated.

Summing the 0's for the columns in rows 1,2, & 3, is easy but you failed to indicate where you wanted the summed number to go.

I wish you the best of luck finding a solution to your problem.

[berbchid]

I'm not sure what happened to the template, I did have the information in it... it must not have uploaded properly. I've re-named it, and am uploading a version that has the stats page, and some information filled in.

templatetickettracker2.xlsm