Need Excel Macro fixed for grade book project

I hired an online programmer to write some macros for my student grade book project but it was designed with a flaw that needs fixing.

(File Attached)

As you can see on the "Export to FM Pro"sheet there are two macros:

The "Convert" macro works fine and has the job of converting assignment names on the "7th grade" and "8th grade"sheets to a naming code that will sync with my Filemaker Pro database.

The problem is with the other macro called "Get". It is supposed to bring over the data on "7th grade" and 8th grade" sheets onto the "Export to FM Pro" sheet and then calculate the averages for each student by category.

The problem is that the "Get" macro only brings over grades extending out to the CY column. In other words, any grades beyond this range get left behind on the "7th grade" and "8th grade" sheets. Hence, the programmer set the ranges too small.

In sum, I am looking for you to expand the range so more grades can be entered and worked on by the "Get" macro. Ideally the macro would be set to take extend out to the max allowed in Excel which is I think 65539. If that is not doable and the macro must be set to a much more limited range then we can chat about that.

Anyhow, here are the details of the workflow I use as mentioned to the original programmer in case you need to know:

I enter students grades into Skyward first. Later I export them as an Excel file. Then I copy and paste the data from here onto the "import from skyward" sheet inside the excel project workbook that has your macros.

Next I copy and paste the "import from Skyward" data into the respective gradesheets for 7th and 8th grade which prepares/groups the data to have the assignment names converted by the "Convert Macro".

Finally, on the "Export to FM Pro" sheets for 7th and 8th grade I use your "Convert" and "Get" macros to first convert the grade assignment names to A1.., B1....., C1.... D1....., E1...., F1......,Effort1.....

The glitch here is that you set the "Grab" macro to work with a range that is too small to capture all the grades when the total number of grades for all categories runs beyond the CY column(in essence I am limited to about 24 grades the way it is now).

Basically, the "Convert" macro works fine. Its that the "Grab" macro will not retrieve/bring over all the grades from the 7th and 8th grade sheets to the "export to FM Pro" sheets:::::it stops at column CY

Skills: Excel, Microsoft

See more: excel macro fixed, excel macro grade database, write my book online, works need excel, work for student online, we fixed it, use case extend, the assignment problem, programmer names, programmer looking for job, programmer job student online, programmer filemaker, online job microsoft, online job as programmer, online job as c++ programmer, online excel works, need of excel programmer, need a programmer for a small project, need a c++ programmer for a job, my excel online, microsoft project import, microsoft programmer, microsoft online job, microsoft excel programmer, microsoft excel online

About the Employer:
( 2 reviews ) Midlothian, United States

Project ID: #1241975

Awarded to:


Excel whiz here.. Please see PM for details.

$45 USD in 1 day
(16 Reviews)