Respected Experts ...kindly help me on creating this macro
Use Vlookup as macro on clicked cell and all cell values below that clicked cell
Tab copied sheet is my sample data on which I want a macro to be created.
Tab Final result as represent the final data which should look like
1) Wherever I click on Tab copied sheet, macro should run and use vlookup as function to tally data with tab Designation and fill all the cell value on and below of that click cell. Example in this case if I click E2, value of E2 till E nth value should change.
2) Data value which it cannot find in Designation tab should not return #na value and the cell value should remain as it is.
**I want this on click function because my column header name for designation can vary from file to file which I receive,also sometimes column headers are in unsorted waydue to which it will be great if vlookup gets applied on click function Format issue resolved.xlsm
Bookmarks