Forum Discussion
Specifically select column 3 to 156 and line 2 to 179 automatically from a database
I want specifically select column 3 to 156 and line 4 to 179 automatically from a database. How to do it?
Using the top left corner of the area you want to select as your reference point, go to Insert....Name....Define, give the area a name of your own choosing, and then enter the formula =OFFSET($C$2,0,0,178,153)
That's a way to do it. Unless you meant by your column numbers the 156th column from that start point, in which case you'd use 156; I was presuming starting in column 3 and going to 159)...but that's the idea. If you want to make your specific selection one that can be dynamic, put the two numbers themselves into cells outside of your database and refer to those cells in your OFFSET formula.
That's a way to do it. Unless you meant by your column numbers the 156th column from that start point, in which case you'd use 156; I was presuming starting in column 3 and going to 159)...but that's the idea. If you want to make your specific selection one that can be dynamic, put the two numbers themselves into cells outside of your database and refer to those cells in your OFFSET formula.
- Thank you for answer! I will answer you i i success!
