I am new to Excel Macro VBA programming. My requirement is to download a records from Oracle DB to excel. Then the business users modify the data in the cells and then upload it back to Oracle. For Ex. I am downloading the below data from Oracle.
Fund Id, Fund Name, Returns.
I want to show fund name and returns in a worksheet. Users will modify the returns in the worksheet and then click a button to upload the data back to Oracle. When uploading the data, i want to use fund id (instead of fund name) to upload the returns to their corresponding IDs. My question is how do i store Fund Id in the cells pertaining to fund names. Is there a way where i can hide the values of fund id in the same cell where i store fund names. Please help me.
Fund Id, Fund Name, Returns.
I want to show fund name and returns in a worksheet. Users will modify the returns in the worksheet and then click a button to upload the data back to Oracle. When uploading the data, i want to use fund id (instead of fund name) to upload the returns to their corresponding IDs. My question is how do i store Fund Id in the cells pertaining to fund names. Is there a way where i can hide the values of fund id in the same cell where i store fund names. Please help me.
