Previous Topic Next Topic

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

Closed
VTUK Posts 2 Registration date Monday 25 March 2013 Status Member Last seen 26 March 2013 - 25 Mar 2013 à 05:43
VTUK Posts 2 Registration date Monday 25 March 2013 Status Member Last seen 26 March 2013 - 26 Mar 2013 à 12:22
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.



Related:

2 responses

Réponse 1 / 2
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
26 Mar 2013 à 10:43
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
Réponse 2 / 2
VTUK Posts 2 Registration date Monday 25 March 2013 Status Member Last seen 26 March 2013
26 Mar 2013 à 12:22
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

Similar discussions

How to modify the macro code for new structure of table
jpppol -
TrowaD -

9 responses
How to create a macro to copy and paste
johncarr1973 -
ac3mark -

3 responses
Convert data with rows into columns
pooja.bs -
TrowaD -

2 responses
VBA code to create Pivot Table
sarisri7 -
ac3mark -

1 response