I want to update value from one sheet to another sheet. Basically Data from the "dashboard sheet" copies to the sheet name reference in the dashboard sheet "C4" with the respective headers. ( Referencing which sheet the data should be updated/edited)
And the highlighted part ( B13:C13) should be filtered to update price and currency.
Please refer to Sheet - "Required Output' for better understanding.
Kindly refer to this macro - sub ADD() from the attached sample sheet which is not working as intended.
Your thoughts are highly appreciated,