line transfer of data to same sheet but on line 50 using 1 of 3 specific cells same line

Greetings,

I am attempting to transfer line data to a specific line location on the same sheet by entering data into 1 of 3 specific cells on the same line. Cells A5-L5 are data filled then cells M5, N5, O5 would be the target cells that when data is entered into one of them the entire line would move to line 50 and color light blue to show completed. the original line would then be blank.


Thank you for your kind assistance,

Elvis

Hello Elvis007,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

Hi Elvis007
Welcome to Excel Forum
Do you realise that this Sub Forum where you have posted is just the Sub Forum to say hello ?

You must start a new Thread in one of the main Sub Forums here, if you need help:

Excel General : http://www.excelforum.com/excel-general/
or here:
Formulas and Functions: http://www.excelforum.com/excel-formulas-and-functions/
or if you would consider a macro solution then here:
VBA Programming: http://www.excelforum.com/excel-programming-vba-macros/

If you are not sure of exactly the type of solution you require, then probably the first Sub Forum will do: http://www.excelforum.com/excel-general/

_............................................

Alan

_..............................................

P.s. Unless someone is very familiar with having done something exactly as you are doing, then I think you may need to give a bit more detail. Some test data is helpful
Remember to reduce the amount of test data to the minimum required to demonstrate typical scenarios. Desensitize the data if necessary.
If appropriate, show us clearly what you have ( The BEFORE ) and the results you want to achieve ( the AFTER ).
Please do not use images !!! as we cannot copy them to a worksheet.

Regarding how to give us that data ( Most people prefer b) to upload a File BUT remember to minimize the amount and desensitise data )

Either:
_a) Post screenshots COPYABLE !!! to a Spreadsheet: ( !!! Not Images please !!! )– See my signature below,
or here:
http://www.excelforum.com/excel-prog...ml#post4399581
Practice here in the Test Sub Forum:
http://www.excelforum.com/development-testing-forum/ ( Start a new Thread. Title it something like “Just Testing, no Reply needed” )
OR:
_b) Upload a Workbook: See here:
http://www.excelforum.com/the-water-...his-forum.html ( ** Use Method 2 and Method 3 ( Method 1 is currently not working )
http://www.excelforum.com/suggestion...ml#post4335120
OR:
There is also the file share site option such as this free thing:
https://app.box.com/signup/personal
(_ .Remember to select Share after uploading and give us the link they provide if you use that )
But Note: a lot of people can’t / won’t download a File from an external site. So this method is not preferred here
For security reasons and to increase your chances of a response, It is preferable to upload a File with no codes in it and post any codes in the Thread ( using Code Tags: [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] ; or Short Cut Editor Icon ( you may need to Hit Go Advanced to see it if Replying to a Thread ) # ).

OR:
_c) Select the table Icon above, select an appropriate size table and fill it in (***If replying to a Thread you may need to select the Go Advanced Button, ( bottom right of reply Window ) to get the Table Icon to show )


You can Practice Posting techniques here:
http://www.excelforum.com/development-testing-forum/
Just start a Thread there with a title like “Just testing, No reply needed”. Or just do a reply to any other Thread were someone is “just testing”
Thanks,
Alan

P.s. Also: Please, also, if you haven’t already , take some time before posting to read the Forum Rules here:

English: http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/showthread...42#post4519006

Other languages: http://www.excelforum.com/forums-rules/
It is usually worth it in the long run.

Thanks