thk12205
10-06-2017, 06:42 PM
Version: Excel 2010 Professional Plus
Hi, beginner VBA user here.
I received a unique request, which was to match abstract "z" values attached to an x-y axis under an opaque isometric CAD visual. (in theory A,B,C would be 1,2,3 on x-axis, and 1,2,3 would be 1,2,3 on y-axis)
The x,y,z output is just three arrays outputted by the CAD program into excel, and the 3 values on each row make a coordinate and value (the first column x-value, the second column y-value, the third column z-value)
So the question is: Is there a simple method using VBA code to read the value from the x array and y array, and place the corresponding z array value (which is on the same row as the x and y array values) into its corresponding cell in another sheet?
So far I've been using the record macro tool, but for this case, I would greatly appreciate if someone could share with me a better/faster/cleaner method using VBA.
Hi, beginner VBA user here.
I received a unique request, which was to match abstract "z" values attached to an x-y axis under an opaque isometric CAD visual. (in theory A,B,C would be 1,2,3 on x-axis, and 1,2,3 would be 1,2,3 on y-axis)
The x,y,z output is just three arrays outputted by the CAD program into excel, and the 3 values on each row make a coordinate and value (the first column x-value, the second column y-value, the third column z-value)
So the question is: Is there a simple method using VBA code to read the value from the x array and y array, and place the corresponding z array value (which is on the same row as the x and y array values) into its corresponding cell in another sheet?
So far I've been using the record macro tool, but for this case, I would greatly appreciate if someone could share with me a better/faster/cleaner method using VBA.