Excel VBA Developer — 7 Documented Fixes to Macro-Enabled Workbook (Spec Provided)

Excel VBA Developer — 7 Documented Fixes to Macro-Enabled Workbook (Spec Provided) Project Overview I have a macro-enabled Excel workbook (.xlsm) for a field-logging application. My client has identified 7 specific issues that need to be resolved before final closure. A complete diagnostic guide is included — every issue has been traced to the exact module / sheet / cell with the precise fix to apply, so this is execution work, not investigation. Estimated focused effort: 5–7 hours. Issues to Fix 1. Mill Run Report — annular velocity formula missing. Even when the formula is entered manually, it disappears when a new Mill Run Report is opened. The fix is in the underlying report *template*, not the live report. The working formula will be provided from a reference master workbook on award. 2. New BHA inserted on the wrong side. When a new BHA is created, it is added to the left side of the last BHA instead of the right side. Single-line VBA fix in an existing sheet-copy macro (`before:=` → `After:=`). Module name and exact line are documented in the fix guide. 3. SO Charges tab — remove the "Import Charges From" button.** This button was previously requested to be removed and is still present. Form control on a protected sheet (password provided in the fix guide). 4. Casing Exit Milling Report — rows + ROP.** (a) The rows below the milling parameters cannot be expanded — every time they are unhidden, they hide again on the next event. (b) No formula is in place for ROP calculation in this template. The working ROP formula pattern used by other milling-report sheets is documented in the fix guide. 5. SRR(R) tab — three non-functioning buttons.** The buttons for *Add new SRR*, *Hide rows*, and *Add rows* are not functioning. The *Add new SRR* button needs a small VBA routine cloned/adapted from an existing equivalent (template exists in the workbook). The other two are macro-assignment or row-range fixes. 6. Tally tab — `#VALUE!` in the "Surface to Bottom, Min" column.** Cells show `#VALUE!` despite all relevant data being entered — most likely a formula operand referencing a text/blank cell. Fix is to wrap in `IFERROR` or correct the input reference. *(Separately, the client has asked for clarification on what value belongs in the "OUT" column — I am sourcing that answer directly from the client and will pass it along; it is not blocking your work.)* 7. Agitator Usage tab — incorrect cross-sheet links.** The milling data and fluid data have incorrect linking formulas applied. The reference master workbook has none — the task is to remove the bad links to match the master file's structure. Reference master workbook provided on award. What You Will Receive - The .xlsm workbook - A detailed fix guide — root cause, module/sheet/cell reference, and exact change for each of the 7 items - The reference master workbook (for items 1 and 7) - Sheet-protection password (in the fix guide) - I am available throughout to answer questions Requirements - Strong Excel VBA experience — must include form controls, ActiveX, protected sheets, and worksheet events (not just formulas) - Must work in real desktop Excel (Windows or Mac). The workbook contains ActiveX, dialog sheets, and VML form buttons that automated/cloud tools strip on save. - Test all fixes in Excel before delivery: open the workbook, click each affected button, verify formulas resolve, confirm protected sheets still behave correctly - Return as a new file — do not overwrite the original Timeline 1 day Budget $100 USD fixed-price. Payment on verified delivery — I will open the file, click through the 7 items, and confirm each is resolved. To Apply In one short paragraph, please tell me: 1. Your specific experience with VBA modules, ActiveX controls, and protected sheets (not just formulas) 2. Confirmation that you have desktop Excel (Windows or Mac) available 3. Your earliest start time I will share the fix guide with shortlisted applicants so you can confirm scope before committing.