I just need to check how data can be moved or mapped easily.
- MS Excel file has all details of a particular person. But the details need to be extracted from one file and needs to be added to another file.
Example: Data would be present in Book 1. And multiple people would have their details in multiple MS excel sheets.
But a consolidated data would be required to be added in Book 2 Is there a solution to automatically get details?