I’m a beginner in excel vba CODING and given a completed project to debug.
Project extracts data from website logistics list and displays data in excel sheet when clicked on macro button “Extract data”. There are a total of worksheets and here are the details:
Current – Displays all the data extracted from the website display all current and updated logistics list.
Previous – Displays old data from previous extracted times
New – Displays only newly added or updated data, for users to identify quickly what logistics are updated or changed.
However, the ‘new’ worksheets does not display any data, need help with vba coding to solve this, so when i click macro button ‘extract data’, current displays all the extracted data from website, new will only display the updated data or new data.
Is there any general code for this? As this is completed project, i do not know where the code is and how to find it
Jia Xing is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.