mike guest98
New member
- Joined
- Jun 6, 2018
- Messages
- 28
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
I need help with new code. There is lots of code to “FIND” but I can’t find anything that writes the cell location of the FIND to specified cells. I can’t use a formula because it will be running with other code.
Using my sample Excel sheet I need code to locate any set of numbers (1-1, 9-9, 20-1 etc.) in the range A3:A35, D9
25 (need to be able to add additional ranges as needed). In my actual sheet there is data above all these sets of numbers.
Sample data is finding 1-1 in cell A3. Using the first number of the set, 1, the code would then search the range G3:G20 for a 1 (please make this cell location changeable) and then write the cell location in the 3rd cell to the right of it G3, so in cell J3 there would be A3. The second example 9-9 found in cell D9 would write D9 in cell J11 (using the first number 9 as the search).
The set of number cells are formatted as text. The sheet number is 2. Using Office 2007.
That would do it. Thanks so much for all your help.
Using my sample Excel sheet I need code to locate any set of numbers (1-1, 9-9, 20-1 etc.) in the range A3:A35, D9
25 (need to be able to add additional ranges as needed). In my actual sheet there is data above all these sets of numbers.Sample data is finding 1-1 in cell A3. Using the first number of the set, 1, the code would then search the range G3:G20 for a 1 (please make this cell location changeable) and then write the cell location in the 3rd cell to the right of it G3, so in cell J3 there would be A3. The second example 9-9 found in cell D9 would write D9 in cell J11 (using the first number 9 as the search).
The set of number cells are formatted as text. The sheet number is 2. Using Office 2007.
That would do it. Thanks so much for all your help.
Last edited by a moderator:
