estatefinds
03-17-2016, 06:39 AM
looking to convert the formula into a Macro to do the same thing formula is doing, please!
Im attaching the file for example.
so the data in the columns AL12:AP84 change.
the numbers in the column AK12 to AK 84 stay the same.
now in the Columns AA AB AC AD AE have a formula =MIN(IF(U11=$AL$11:$AP$46,$AK$11:$AK$46)) now this formula works with the values in the columns U V W X Y and this correlated to the graph to the right the in columns AL12:AP84.
so I need the formula to be changed to a VBA.
so the values that are in the columns U V W X Y for example are 2 15 16 25 26 these numbers are found in the chart of numbers in AL12:AP84m so the number 2 is found in the chart AL12:AP84 in column AM and found on the same row labeled 1 in column AK, number 15 in column V is found on same row labeled 6 in column AK. and number 16 found on row labeled 8 in the column AK. 25 found and is in column AK on row labeled 7. and the number 26 on the column AK labeled row 8.
there is a reason I need this to be a VBA as the way this data will be working I need to be un limited by where the data in the columns U V W X Y and columns AA AB AC AD AE and how I record them. to explain the data I enter for example in the columns U V W X Y the macro will interpret where number the number is found in the the chart of numbers and what row it is found on, and what I mean the row labeled in the column AK.
(Also the word "DONE" will be placed after the data entered into U V W X Y into the the column Z.)
So once that information is displayed in the columns AA AB AC AD AE the column to the right column AF will display the word "DONE". then When I enter another value in to the U V W X Y below the last data entered; based on the changed Data in the AL12:AP84 will have a different result in the columns AA AB AC AD AE and will results the word "DONE" so when I run the new data this data before the word "DONE" will not be changed.
Thank you!
Im attaching the file for example.
so the data in the columns AL12:AP84 change.
the numbers in the column AK12 to AK 84 stay the same.
now in the Columns AA AB AC AD AE have a formula =MIN(IF(U11=$AL$11:$AP$46,$AK$11:$AK$46)) now this formula works with the values in the columns U V W X Y and this correlated to the graph to the right the in columns AL12:AP84.
so I need the formula to be changed to a VBA.
so the values that are in the columns U V W X Y for example are 2 15 16 25 26 these numbers are found in the chart of numbers in AL12:AP84m so the number 2 is found in the chart AL12:AP84 in column AM and found on the same row labeled 1 in column AK, number 15 in column V is found on same row labeled 6 in column AK. and number 16 found on row labeled 8 in the column AK. 25 found and is in column AK on row labeled 7. and the number 26 on the column AK labeled row 8.
there is a reason I need this to be a VBA as the way this data will be working I need to be un limited by where the data in the columns U V W X Y and columns AA AB AC AD AE and how I record them. to explain the data I enter for example in the columns U V W X Y the macro will interpret where number the number is found in the the chart of numbers and what row it is found on, and what I mean the row labeled in the column AK.
(Also the word "DONE" will be placed after the data entered into U V W X Y into the the column Z.)
So once that information is displayed in the columns AA AB AC AD AE the column to the right column AF will display the word "DONE". then When I enter another value in to the U V W X Y below the last data entered; based on the changed Data in the AL12:AP84 will have a different result in the columns AA AB AC AD AE and will results the word "DONE" so when I run the new data this data before the word "DONE" will not be changed.
Thank you!