Hi Guys,

I am working in charity school where I have two workbook one is student fees record having 6 different columns for fees A and Date , fees B and Date, Fees C and Date, of different classes in different sheets of a 'STUDENT-FEES' workbook.. I have created command button which will create click event and will send a DATE from one cell to function in VBA and then check that date with all the cells in these column in all the sheets and will copy the fees record along with the name in other workbook named 'DAY-SUMMARY'

at the end of the day i have to give the summary printout for total fees from all the classes from different sheets from STUDENT-FEES workbook altogether

The loop will have to go through date coloumn and where it gets the date equals will copy the whole row to other workbook..... after checking from one sheet it will move to next sheet and perform the same ......


thx in advance