Select row based on cell value

[FullStackFailure]

Hello Excel Forums! First time poster here (Just created an account just now). My question is this. Is there a way to select a row based on the value in a cell?


Cell A1's value is 105
So I want to have row 105 selected


Is there a way to do this? I'd like resources and/or hints instead of the complete answer. Thanks in advance!

[AliGW]

Welcome to the forum.

The way I would approach this, honestly, is like this: https://www.google.co.uk/search?q=vb...client=gws-wiz

Does this provide the sort of hint and/or resources you need?

[Marc L]

Hello !

Is there a way to select a row based on the value in a cell?

Yes under a VBA procedure but as any good enough code does not need to select anything
so the question is : what is really the final purpose ?!

[FullStackFailure]

The final purpose is based on a cell value I want to copy contents of 3 cells in that row into another spreadsheet tab. Does that make sense?

[Marc L]

So according to cell A1 content aka 105 what are those « 3 cells » you want to copy and where ?!

As Accuracy leads to a proper & quick solution …

[AliGW]

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. Normally I would provide the link for you, as you are new. I understand the cross-post is on the MS Office Forums.)