This probably seems like a odd request. Here it goes. I have have a range of cells from a2:e(variable) in source worksheet. Row 2 is always a header. What I want is to copy single cell in column b starting in row 3 row by row in descending order to corresponding cell in target sheet until the last row number of data in column e is reached.
Example, I have data up to row 4 in column E. Do this: Copy B3 in source paste to B3 in target and Copy B4 in source paste to B4 in target. Complete.