Search results

Hi SirJB7, Due to my tinkering with the layout I forgot to change the Macro's coding. Origionally it Surname was Column B and Forname was Column C. I would past the data in, which started in Column C (Surname,Forename) and attandance data (column D). when The button was pressed the Macro...

Hi SirJB7 (&Faseeh!), Thank you for your time and effort! I have had a good look through it now and see what you have done! I'll go through what you have put and reply to each :-) a) week one was different as there was no need to comparison (as it is the first week). it did need cleaning...

Hi all, Sorry for the late responce, have been out of the office for a couple of days. I have uploaded a sample file for you to have a look at and see what I am so poorly explaining! https://docs.google.com/open?id=0BxwE5_UqQAI5eFg2cHpoaVVUMUdiOTdsdHdSLU42dw When I copy and paste the next...

Hi! Thanks again for the reply. So now I have the columns ordered I want to take the data and compare them week by week. So "week 1" I will have the raw attendance data, "week 2" (sheet 2) will have the new attendance data and will compare that (student by student)to the previous sheet. This...

Hi Faseeh, Thanks for getting back to me. Unfortunatly the program from which I extract the attendance data does not give a fixed number such as student ID (annoying I know).The only fixed thing is their name. I have columns arranged as follows... Surname - Forename - This Weeks attendance...

Hi all, I have a database of students at my work place. It is a list of names and their attendance. There is a sheet for each academic week with their name, current week attendance, weekly comparison and their overall attendance (along with other info). The problem I have is that students...