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
VTUK Posts 2 Registration date Monday March 25, 2013 Status Member Last seen March 26, 2013 - Mar 26, 2013 at 12:22 PM
Related:
- Macro: Copy row to another header or sheet from a drop down
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro on opening workbook - Guide
- Excel vba assign macro to button programmatically - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 26, 2013 at 10:43 AM
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
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
VTUK
Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 26, 2013
Mar 26, 2013 at 12:22 PM
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
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