Move a row of Date

-emma-

Board Regular
Joined
Jul 14, 2006
Messages
180
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

-emma-

Board Regular
Joined
Jul 14, 2006
Messages
180
Office Version
  1. 365
Platform
  1. Windows
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
 
Upvote 0

-emma-

Board Regular
Joined
Jul 14, 2006
Messages
180
Office Version
  1. 365
Platform
  1. Windows
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>
 
Upvote 0

Forum statistics

Threads
1,190,703
Messages
5,982,395
Members
439,777
Latest member
daleEH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top