D
David Frank
Worksheet1 has cell A1 equal to contents of cell E1 on worksheet2. I want to
copy that down through A50 so that A2 equals contents of E1 on worksheet3, A3
equals E1 on worksheet4 etc. I have two problems, 1) I dont know a formula
for incrementing worksheet name by one/next worksheet name. 2) E1 reference
increments to E2, E3 etc when I copy it down through A50. Any idea on a
formula for this?
copy that down through A50 so that A2 equals contents of E1 on worksheet3, A3
equals E1 on worksheet4 etc. I have two problems, 1) I dont know a formula
for incrementing worksheet name by one/next worksheet name. 2) E1 reference
increments to E2, E3 etc when I copy it down through A50. Any idea on a
formula for this?