I am an intermediate Excel user with beginner skills in vba.
I have three spreadsheets containing columns of data to compare.
Sheet1.Column# compares against Sheet2.Column# and returns the value of Sheet2.Column##.
The values returned from the first For. .Next loop are then passed into a 2nd For. .Next loop to compare to a column in Sheet3.Column#
I have three spreadsheets containing columns of data to compare.
I believe I need to execute multiple For..Next loops.
I need the 1st loop to take values from Sheet1.Column# and compare them against Sheet2.Column#, and return the values of Sheet2.Column## for all TRUE conditions.
I then need to Pass those returned values into a 2nd For. .Next loop to compare against data in a column in Sheet 3, returning the entire record for any comparisons that have a False condition.
I also think I need to have a Row variable that works from a counter variable "i" that is incremented to execute the comparison statement for each successive row of Sheet 1.Column 1 against the Sheet 2.Column 1 values.
I really need help in writing the code for this procedure.
Please Help.
.
I have three spreadsheets containing columns of data to compare.
Sheet1.Column# compares against Sheet2.Column# and returns the value of Sheet2.Column##.
The values returned from the first For. .Next loop are then passed into a 2nd For. .Next loop to compare to a column in Sheet3.Column#
I have three spreadsheets containing columns of data to compare.
I believe I need to execute multiple For..Next loops.
I need the 1st loop to take values from Sheet1.Column# and compare them against Sheet2.Column#, and return the values of Sheet2.Column## for all TRUE conditions.
I then need to Pass those returned values into a 2nd For. .Next loop to compare against data in a column in Sheet 3, returning the entire record for any comparisons that have a False condition.
I also think I need to have a Row variable that works from a counter variable "i" that is incremented to execute the comparison statement for each successive row of Sheet 1.Column 1 against the Sheet 2.Column 1 values.
I really need help in writing the code for this procedure.
Please Help.
.