I apologize the image I used was not visible but my 10 min edit time exceed so I am including more details on the issue in this post.
I have an Excel spreadsheet that has 3 columns and thousands of rows.
The value in the third column indicates which row to copy. I am looking to copy the value from column A to column D if C has a value.
Then based off the number in C copy the value from A to E
If row 1 column C1 has a any value (greater 1 or greater) then D1 has the value of A1
Using the value in C1 it will determine which row to copy the value of column A from in the example row 1 below has a value of 1.
This would populate A1 into E1
Row 7 below C7 has a value of 4
This would cause D7 to be populated with the value from A7 (same as above)then using the value 4 go down to row 10
copy the value from A10 to E7
A B C D E
<colgroup><col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:585;width:12pt" width="16"> <col style="mso-width-source:userset;mso-width-alt:1024;width:21pt" width="28"> <col style="mso-width-source:userset;mso-width-alt:3145; width:65pt" span="2" width="86"> <col style="width:48pt" span="2" width="64"> </colgroup><tbody>
I know it is a simple one, but the options I have tried are simply not giving me the results. Any help will be appreciated.