macro to reorganize date

[bill mccann]

I am trying to create a macro which will reorganize a database. It consists of student names, date of month, and number of hours worked. That data needs to be reorganized to produce a list with student name, date, and hours for each of the student and date combinations.Book1.xlsm An example of what I have and what I need is attached.

My problem comes from the fact that there are a different number of days in each month, and variable number of students, so the macro has to detect blank cells.

[bryanbak3]

It is hard to say for sure without you having a sample work sheet up, but you should be able to put if statements around any formula you are normally typing to account for possible empty cells. Ex. If(whatevercell<>0,normal formula,0 or other value)

[NickyC]

Not sure if this is what you want.

Assuming

1. Your list is on “Sheet1”
2. your days are in cells B2, C2, D2 etc and
3. your names list starts in cell A2 and continues down,

this macro will create a list like the one you specify on Sheet2 (to allow for variable numbers of date columns on Sheet1) of your workbook for every cell where there is a data value in the table, a student name in column A and a date on row 2:

Please Login or Register  to view this content.

[bill mccann]

Thank you very much NickyC. Its works well, and will be real time time saver for us! Thanks again.