I am in urgent need to perform below - Data Given: There are two xls sheets, one is master have a no of columns and another is slave sheet. Both sheets have employee ID common in first column. Sheet 2 may have few columns which is not in sheet 1 but that column of sheet 2 does not required an update or delete. Action Required: I need to check that first column of sheet 2 which employee ID has matching value in sheet one. If EMP ID is found in sheet 1 than I need to copy entire column (except employee id column) of sheet 1 into sheet 2.While create column and copy values-if there is an additional different column in sheet 2-that should not be impacted. Is it possible to create a macro for above need ?If yes I would request if someone can plzz help me.
closed as off-topic by Pieter Witvoet, Denis, IEatBagels, Toby Speight, Dannnno Oct 11 at 14:54
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – Pieter Witvoet, Denis, IEatBagels, Toby Speight, Dannnno