Hi experts!
Desperate for help as I don't even know where to start on this one..
I have a workbook containing 4 fixed sheets - 'Faktura', 'Oversikt', 'Start' & 'End'. On one of the sheets there is a button letting users create new sheets (via a user form) between the 'Start' and 'End' worksheets. The user-created worksheets will all have a date in cell F6 and two numbers in cells F37 & F40. There will be an ever-growing number of sheets. On the 'Oversikt' sheet in column G (G1 to G12) there are the names of the months.
What I would like to do is this:
- Sum cell F40 on all worksheets except the 4 fixed sheets - based on the condition (date) in cell F6. I need to summarize & "categorize" these by month on the sheet 'Oversikt' in cells G1 to G12. So if there are three sheets with different dates in cell F6 between 'Start' & 'End' - for example Sheet1 has 2012-06-01 in F6, Sheet2 has 2012-06-13 in F6 and Sheet3 has 2013-01-01 in F6 - I want the sum of cell F40 on Sheet1 and Sheet2 to go in cell F6 (G6 holds "June") on the sheet 'Oversikt 'and the sum of cell F40 on Sheet3 to go in cell F1 (G1 holds "January") on the sheet 'Oversikt'.
This macro would preferably update dynamically with the adding and removing of sheets but if thats to complicated then perhaps it could be assigned to a button. Also, each time the macro runs it would need to delete the previous values in cells F1-F12 so as to avoid duplicate values..
Any help would be very much appreciated!
Bookmarks