Add a Macro to an Existing Excel File

We have an existing Excel file with 10 macros already implemented. We need to add one more macro to the file. The task involves capturing data between two specified columns using a formula (e.g., "=")... (Budget: ₹600 - ₹1000 INR, Jobs: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps)