Macro to deleted data from a different file
Budget: ₹1,500 – ₹12,500 INR
I need to assign a macro code to a button which asks to select the file from where the specific data needs to be removed.
Eg. There are two files:
1. Macro File
2. Data File
Macro file contains the button which when pressed opens the box to select the Data File from which the specific data (rows/columns) needs to be created.
Data that needs to be deleted are all the line items mapped to the "GBSS" and "Procurement" under the column "Issues_Investment" in the sheet "Issue" and "Risks_Business_Area" in the sheet "Risks".
Eg. There are two files:
1. Macro File
2. Data File
Macro file contains the button which when pressed opens the box to select the Data File from which the specific data (rows/columns) needs to be created.
Data that needs to be deleted are all the line items mapped to the "GBSS" and "Procurement" under the column "Issues_Investment" in the sheet "Issue" and "Risks_Business_Area" in the sheet "Risks".