- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Need some Excel help
Posted on 1/15/15 at 12:17 pm to Guess
Posted on 1/15/15 at 12:17 pm to Guess
You have to create a Macro.
If your Developer Tab is not visible, add it by customizing the toolbar ribbon under "File:Options". Once you have the developer ribbon displayed, then simply click on Developer->Insert->Form Control->Button
It will popup with the list of Macros to assign to the button. Select the macro you want. The one I have above basically copies the active row and inserts it directly below. So basically, each new row is an exact duplicate of whatever row is currently active.
You can dress this up by specifying the active range to copy from -- that way instead of relying on the user to have the "right row" highlighted, it always copies the same row and inserts it into the same place in the sheet.
quote:
Sub macroNewRow()
ActiveCell.EntireRow.Select
Selection.Copy
Selection.Insert Shift:=xlDown
End Sub
If your Developer Tab is not visible, add it by customizing the toolbar ribbon under "File:Options". Once you have the developer ribbon displayed, then simply click on Developer->Insert->Form Control->Button
It will popup with the list of Macros to assign to the button. Select the macro you want. The one I have above basically copies the active row and inserts it directly below. So basically, each new row is an exact duplicate of whatever row is currently active.
You can dress this up by specifying the active range to copy from -- that way instead of relying on the user to have the "right row" highlighted, it always copies the same row and inserts it into the same place in the sheet.
Posted on 1/15/15 at 3:37 pm to Floating Change Up
I ended up using =IF(ISBLANK(A2),"",A2+Timel(0,29,0)) and dragged just dragged it down.
Popular
Back to top
![logo](https://images.tigerdroppings.com/images/layout/TDIcon.jpg)