Data_Admin

Hi Sam, that was just a typo in this message it was spelt correctly in excel code. I don't think it would have worked at all with a typo in code. Always something to be mindful of though. Thanks.

Works an absolute treat! Many thanks Mukesh. I like the smiley emoji in your code. Olivia

Hello all, I recently attended the SIMS advanced reporting with excel analysis training course and have been having a play with some attendance reports. I managed to use the following code to copy a formula down the required amount of cells in my student data tab. Sheets("Student Data").Select Dim r As Integar r = ActiveSheet.Range("A1").End(xlDown).Row Range("p2")Select Selection.AutoFill Destination:=Range("p2:p"&r) I have tried a few different ways to get this to work for multiple (6) different columns but am still struggling to get it to happen. I have a Compile error message which stated 'Wrong number of arguments or invalid property assignment'. Any suggestions gratefully received. Olivia