View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
magmike[_2_] magmike[_2_] is offline
external usenet poster
 
Posts: 35
Default DREAM FEATU A macro that moves a row but asks me where to move it

Can you give me an example of how to use it?

On Wednesday, December 18, 2013 9:53:00 AM UTC-6, magmike wrote:
I would love to have a macro, that when a button is pushed, will move the selected row (or A:AP) and asked me where to move it. I don't know if a pop-up message box with buttons to push or a combo box with selections to click or another way is best, but based on the selections picked would move the row either to a new place on the current sheet or to another sheet. For example: "Potential" = sheet2 (inserted above row 3) "Future" = sheet3 (inserted above row 3) "Ageement Sent" = insert above row 3 on current sheet When the macro has completed, I would like the previous row not to be left empty but to be deleted. M I asking too much of Excel? Thanks in advance, magmike