Mike Guest98
New Member
- Joined
- Jun 4, 2018
- Messages
- 42
Hi
Im a newbie to Excel and have spent many hours with no luck on this one. Im trying to find the location of a manually entered number, 1 to 10 is the choice. So the number gets entered in cell C17, say number 4 as an example.
Using VBA I need it to search the following 5 column locations: C30 TO C50, E30 TO E50, G30 TO G50, H30 TO H50 AND L30 TO L50. Each column has a number 4 but only one 4 has a value in the cell to the right of it. So as an example IF it finds 4 in C30 and a value in D30 it is a positive (if their was no value in D30 it would be negative).
Now I need the value in cell D30 to be copied and pasted in cell F10.
The end
Thanks in a advance for any help.
Mike
<style type="text/css">p { margin-bottom: 0.1in; line-height: 115%; }</style>
Im a newbie to Excel and have spent many hours with no luck on this one. Im trying to find the location of a manually entered number, 1 to 10 is the choice. So the number gets entered in cell C17, say number 4 as an example.
Using VBA I need it to search the following 5 column locations: C30 TO C50, E30 TO E50, G30 TO G50, H30 TO H50 AND L30 TO L50. Each column has a number 4 but only one 4 has a value in the cell to the right of it. So as an example IF it finds 4 in C30 and a value in D30 it is a positive (if their was no value in D30 it would be negative).
Now I need the value in cell D30 to be copied and pasted in cell F10.
The end
Thanks in a advance for any help.
Mike
<style type="text/css">p { margin-bottom: 0.1in; line-height: 115%; }</style>