Using Lookup + Row functions with Go to (F5)

[buyshirts]

I have recently come across Goto (F5) and wondered if i could use Lookup + Row function so that i can return into a ceel to input more data?

 

[Joe4]

I am not quite sure I follow what you are trying to do.
Can you post a small sample of your data and walk us through an example of what it is you are trying to do?

 

[buyshirts]

So you can see i have over 3000 rows of data and then there is the Go To feature where you can selct an entry what i wanted to know could you add a Namelist and have that which dynamically selects the cell after the last entry

 

[Joe4]

I see your data, and see that you have some named ranges.
But I still do not understand what you are trying to do.

Can you actually walk me through an example, like I asked?
If we can see exactly what it is you are trying to do, perhaps it will make sense to us.

 

[buyshirts]

So i want to create a Named range and the name range would select A3180 on the worksheet called Data this would then come up in that list of name ranges and i could just go F5 on any of the worksheets in that file and that would then take me to the cell below the last entry (which currently is A3180)

 

[Joe4]

If you have a named range, you can go to that range using the F5 key.
But if you want to go to the cell below that named range cell, I don't think you can do it with the F5 key. I think you would need VBA to do something like that.

 

[buyshirts]

Thanks for the replies im happy to work with the VBA if you know the soultion

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Finding the 1st blank cell in a column and returning the Cell reference
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.