estatefinds
08-21-2016, 07:52 AM
I have Data in column A at row 20; numerical data. this data I enter everyday.
In column AN have numerical data that is a set data and in column AO data that is colored with alpha numerical data that is assisnged to the numerical data to make up the master list in which the macro would be running off of.
So I need a macro that would look at the data in column A and then return the the data that is attached to that number in the master key and place result in the column AH. so in the example Im attaching so for the number 2456 in column A the result will be "R TO V" shaded in green to the right in column AH row 20.
Any help with this will be greatly appreciated. Thank you in Advance!:)
In column AN have numerical data that is a set data and in column AO data that is colored with alpha numerical data that is assisnged to the numerical data to make up the master list in which the macro would be running off of.
So I need a macro that would look at the data in column A and then return the the data that is attached to that number in the master key and place result in the column AH. so in the example Im attaching so for the number 2456 in column A the result will be "R TO V" shaded in green to the right in column AH row 20.
Any help with this will be greatly appreciated. Thank you in Advance!:)