select a sheet from a drop down menu and move the row in the selected sheet

**AlienPump** · 04-25-2012, 08:24 AM

Guys,

Hello again. I have been able to get some really good help from you and I am hoping that I would be able to get some assistance one more time.

I have this sheet: 4_25.xlsm with tickets and I am trying to come up with a way to easily move the tickets within the different teams.
So I was thinking that maybe there can be a drop down menu generated in column "I". When a team is selected from there the whole row would be moved to the appropriate team's sheet.

If anyone has an idea on how I can accomplish that, I would greatly appreciate if you would share it with me!
Thank you guys in advance.

**FDibbins** · 04-25-2012, 10:11 AM

trying to figure out where you want to put this. could you add a before and after example in your workbook?

**AlienPump** · 04-25-2012, 10:46 AM

I currently have a script that generates the link in "A" and the date in "H" when something is entered in "B", so my idea is to have the drop down menu generated in "I" with a list of "mine" "LAN" "voice" "8k" "SD" and "TC". Selecting one of those entries will send the row to the corresponding team's sheet.
for example:
I generate my entry (paste the NA REQ and "name" in the appropriate cells" in sheet 'mine') and I start working on the ticket, but for example I might need to escalate it to one of the teams, for example to the LAN team - I currently cut and paste between the sheets, but was hoping to have this automated with either a drop down or radio buttons
and I would get the row:
℮ NA12345 REQ987654 Jones 2-Apr-12
screen2_1.jpg
from the sheet 'mine' to the sheet 'LAN' :
screen2.jpg
And than if need be, I would have the option to move it to another team (for example 'voice') and so on..
I hope this clears things.

**AlienPump** · 04-27-2012, 05:07 AM

Guys,
does anybody have an idea if this is actually possible - to have a radio button or a drop down menu, with the help of which to move rows around between the sheets?
Thanks in advance to anyone who might be able to provide any assistance.

**jaslake** · 04-27-2012, 02:21 PM

Hi AlienPump
It seems to me you could use Data Validation in the column I cells and a ChangeEvent code to move the row when column I changes.
You have existing ChangeEvent code so you're familiar with it...do you need assistance with this additional code?