VBA Autofill

[joshrescue62]

Hi all,

This is probably something pretty easy, I'm just not at all familiar with vba.

I have a grade book that I am using for my class this semester. I have entered in it my 15 students names, with each of there 5 test scores in columns (B3:F3) and class average in column (G3). I would like to create a macro that will insert a column in between F3 (the 5th test) and the Class average (G3), since there will be other tests I would like to input into this spreadsheet. I would like the heading to autofill from cell F3 (Test 5), and I would like it to say (Test 6) in G3. I would also like this macro to insert holding 0's in the new column (G) inserted for rows 4:19.

If anyone could help me out, it would definitely be very appreciated.

I hope this isn't too complex . If you need more information or pictures, let me know.

Thanks,
Josh

 

[joshrescue62]

j_harr,

Works like a charm, Thank you so much!! ray:ray:

Josh

 

[j_harr]

No problem, I'm glad to hear it works for you.