Dear Forum,
I have data spread over several columns and this data is added from different files which has a different format than the one required to be in the Consolidated File.
I get results from a portal for Insurance certification, which has Exam Date, Issue Date and Validity Date which is copied manually and pasted from this file and to my master consolidated sheet...then I have to fetch other details for these certified employees from the HR Database which has the data in different formats...
So have to manually copy the format from the previous rows and then copy to the copied data, since this is done more than once in a day its tedious and time consuming so can this be done with a Macro..
I made my own small code but dont know how to make it act differently on selected columns....
I would select the entire matrix and then want the macro to run differently, taking into consideration the column names
I also need to add a vlookup formula for some column based on the column B's value...![]()
Please Login or Register to view this content.
Ex: ;this is for Col C
So how do I write the code in such a way that the code acts on its own differently![]()
Please Login or Register to view this content.
Regards
e4excel
Bookmarks