Ok guys, this should be a real easy one for the experts.
2 Quick questions
1. piece of code to run through range A2:A26 And generate a list in column E of the values of only the cells in that range with the cell to the right of it in column B that has a value. Example:
A2's value is "501" and B2's value is "Joe"
A2 makes the list.
A3's value is "502" and B2 is blank
A3 is ignored
A4's value is "503" and B2's Value is "John"
A4 makes the list directly under A2
So, E1 = "501", E2= "503", etc...
2. piece of code that will run through range A9:A28 of 60 different worksheets and generate a list of the values of only the cells in those ranges that are have value in a seperate worksheet. List cannot have any gaps.
2 Quick questions
1. piece of code to run through range A2:A26 And generate a list in column E of the values of only the cells in that range with the cell to the right of it in column B that has a value. Example:
A2's value is "501" and B2's value is "Joe"
A2 makes the list.
A3's value is "502" and B2 is blank
A3 is ignored
A4's value is "503" and B2's Value is "John"
A4 makes the list directly under A2
So, E1 = "501", E2= "503", etc...
2. piece of code that will run through range A9:A28 of 60 different worksheets and generate a list of the values of only the cells in those ranges that are have value in a seperate worksheet. List cannot have any gaps.