Macro: Copy row to another header or sheet from a drop down

Closed
VTUK
Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 26, 2013
- Mar 25, 2013 at 05:43 AM
VTUK
Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 26, 2013
- Mar 26, 2013 at 12:22 PM
Hello,

I am creating a spreadsheet which contains a drop down list of categories. I am looking for a solution so when a category is selected it will move the row of data to either under a heading or into a new sheet which ever will work easier?

Any help is appreciated.



2 replies

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Mar 26, 2013 at 10:43 AM
Hi VTUK,

Could you show how your data looks like and how you would like to see it?

You could use a filesharing site like www.speedyshare.com.

Best regards,
Trowa
0
VTUK
Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 26, 2013

Mar 26, 2013 at 12:22 PM
Hi Trowa,

thank you for your reply.

http://imageshack.us/a/img703/8208/42246048.png for the spreadsheet layout.

So I am trying to create the spreadsheet, so that when I select a risk from the drop down, the entire row moves into high/medium/low heading? If that is not possible, I was thinking about having high / medium / low on different sheets with the drop down. So if a low risk client becomes a medium, I select the relevant one from the drop down and it'll move section without having to cut/paste.

Any help appreciated.

Jake
0