Move a row of Date

[-emma-]

Hi all,

I need to move a row of data once a button is pressed. There is alot of more to it than just that though...

Each row needs 6 columns of data in before the row can move. (I dont want incomplete data being moved). 1 - 5 will already be imput. The 6th is a drop down menu, and depending on the choice in 6 will depend where the row will move to. The drop down has 10 possible outcomes and each outcome has a corresponding tab. Once the drop down box has been completed the user presses a button and the choice will move the row to that tab to the next available row. Also, the information underneath the first tab will move up so not to leave any gaps...

I hope this makes sense. I can post an example if needed.

Thanks in advance.

Emma x

 

[VoG]

Emma

This is a very similar request http://www.mrexcel.com/forum/showthread.php?t=378511

It may help you.

 

[-emma-]

Thanks for the quick reply.

Unfortunatly, I have no clue how to re-write this code or amend it to fit into my secnario.

Emma x

 

[VoG]

Try using http://www.excel-jeanie-html.de/html/hlp_schnell_en.php to show what you have and what you want.

 

[-emma-]

This is the main tab. Once the end column is filled in and the "press" button is hit, the record moves to the correct tab whichever is chossen in the end column

<a href="http://xs.to/xs.php?h=xs137&d=09123&f=1.220.jpg" target="_blank"><img src="http://xs137.xs.to/xs137/09123/1.220.jpg.xs.jpg" title="Free image hosting powered by xs.to"></a>

Once the information moved its slots in here

<a href="http://xs.to/xs.php?h=xs137&d=09123&f=3.828.jpg" target="_blank"><img src="http://xs137.xs.to/xs137/09123/3.828.jpg.xs.jpg" title="Free image hosting powered by xs.to"></a>