Edit a script to work with Column G instead of A

[Mr_Bill]

I have script that inputs data in two locations however I have ran into a hiccup. When I try and input my data it is putting it in columns A:E and not G:K

The first part of this script is working perfect however the part in the section "Data Input for active gradebook weighted key is not". Also is it possible to wrap a if around that part based on if G3 says percentage dont do this if G3 say weighted do this? It might be something I want to add later so figure I may as well try to get that part also.

Thank you

Please Login or Register  to view this content.

Last second thought *** Can vba do formulas such as Sumif average and VLOOPUP on a veryhidden sheet?

[millz]

Hi Bill, I've highlighted the lines below that shows where the data is input into the worksheet.

I am not sure what you mean by your second question, need to see an example.

Formulas can work on hidden sheets.

Please Login or Register  to view this content.

[Mr_Bill]

Thank you again sir.

The second part was if I am using a weighted book so G2 would say "weighted" then do this part of the script. But if it said "percentage" in G2 dont do this part since I dont need these figures for the standard ones.

Want to see what it looks like so far? I think I am done aside from getting the formulas added in and putting the sorting back in. Had a hard time with the images not copying correctly.
Still a few things left but not much just some tweaks and getting the grading system working. Trying to figure out if I want to do the formulas in vba or use a hidden or veryhidden sheet and vba to input the results in the right cells.

[millz]

Sure, Bill. Let me see with some sample data in the workbook too, to get a better idea.