Previous Topic Next Topic

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

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
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
Answer 2 / 2
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