VBA - How to find and then copy and paste info to another cell

[Mike Guest98]

Hi

I’m a newbie to Excel and have spent many hours with no luck on this one. Using actual cell locations here is the project:


1) In cell C17 I enter one number, can any number from 1 to 10. Lets say I choose the number 4 as an example.


2) I have 5 locations where number 4 could be located: C27 TO C36, F27 TO F36, I27 TO I36, L27 TO L36 AND O27 TO O36. Note each column has a number 4 but only one has a value in the cell to the right of it. So as an example IF it finds a 4 in cell F27 and a value such as 1-1 in F28 it is a positive (if their was no value in F28 it would be negative).


3) If it’s a positive (a value in cell F28) I need it to copy and paste the 1-1 in cell J3.



The end

Thanks in advance for any help you can provide.

Mike
<style type="text/css">p { margin-bottom: 0.1in; direction: ltr; color: rgb(0, 0, 10); line-height: 115%; text-align: left; }p.western { font-family: "Liberation Serif", serif; font-size: 12pt; }p.cjk { font-family: "WenQuanYi Micro Hei"; font-size: 12pt; }p.ctl { font-family: "Lohit Devanagari"; font-size: 12pt; }</style>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...then-copy-paste-another-cell.html#post5081800

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.