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

[Closed]
Report
Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 26, 2013
-
Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 26, 2013
-
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

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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
Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 26, 2013

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