Hi All! Cool new board!
Not sure if loop function is what i need.....
I wish to copy a row (A1:Z1) from sheet1! and paste to row (A1:Z1) sheet2!, then change row Sheet1!A1:Z1's contents (via a series of VLOOKUP's) and paste to Sheet2!A2:Z2, then A3:Z3, A4:Z4, etc......but always copying from the same row in Sheet1.
Excuse my inability at communicating my problems! always the case!
Cheers!
Lucky
Not sure if loop function is what i need.....
I wish to copy a row (A1:Z1) from sheet1! and paste to row (A1:Z1) sheet2!, then change row Sheet1!A1:Z1's contents (via a series of VLOOKUP's) and paste to Sheet2!A2:Z2, then A3:Z3, A4:Z4, etc......but always copying from the same row in Sheet1.
Excuse my inability at communicating my problems! always the case!
Cheers!
Lucky