Function auto increment
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
The same way, but start with this:
=Sheet1!$A1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Perfect, thankyou.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks