1. I have worksheet A with cells A1, A3, A5 filled in.
2. I have worksheet B. In worksheet B I want to drag down A1, A2, A3 showing A1, A3,A5 from worksheet A
The 1st cell is easy ='A'!A1
the 2nd cell ??
the 3rd cell ??
Little flustered. The series would be skipping 1 cell each time but how do I show that in a formula form so dragging it down will be simple for bigger examples.
Thank you.
Bookmarks