Our inventory costing workbook uses VBA macros written by someone who left. Since we passed 250,000 rows it throws "Run-time error 1004" and takes several minutes to refresh. I need the macros read, the errors fixed, the slow loops replaced with array operations, and the sheet protected so formulas cannot be overwritten by mistake.

Finance rebuilds the numbers manually each month-end, which takes two days.

Key Deliverables:

• Data Ingestion & Initial Processing: Importing source data, establishing processing rules, and test sample verification.

• Full Processing & Verified Delivery: Completing remaining records with clean audit trail and final reconciliation.

Requirements:

• Demonstrated experience with Excel, VBA, Financial Modeling, Data Analysis

• Quick turnaround needed — must be available to start within 24 hours.

• All company financial files stay strictly within our platform workspace.

Please include links or examples of similar projects you've completed when submitting your proposal. Thanks!

[!NOTE]

Notice: Data & Business projects involving bookkeeping or financial reconciliation are administrative support only. Not certified public accounting or tax advice.