Evening all,
On Sheet 1;
A1 Simon
A2 Peter
A3 Heidi
A4 Tom
A5 Sam
A6 Penny
A7 Ralf
etc ..
etc..
On Sheet 2
A1=Sheet1!$A$1 ....AKA (Simon)
A2=Sheet1!$A$2 ....AKA (Peter)
Id like to Select Column A On Sheet 2 and have it pull the data from the corresponding Cell on Sheet 1 without typing it out manually
You Can do this with numbers by dragging the little square on the bottom right of a cell downwards
How can you do this with a function? Drag A formula??
Thank you
Bookmarks