| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rusty at excel, could use a hand with a macro
I am making a program to show work done on a home, and have a pile of old receipts to input.
I have pulled down in first column dates involved, but end up copy/paste any date that has more than one receipt, so would like a macro that I can click on a date and have it insert a line underneath with same date. |
|
#2
|
|||
|
|||
|
This I tried....no workie
Sub AddLine()
' ' AddLine Macro ' Adds a line with same date under chosen line ' ' Keyboard Shortcut: Ctrl+l ' Sub Paste_OneRow() 'Copy and Paste Row Range("1:1").Copy Range("2:2") 'Cut and Paste Row Range("1:1").Cut Range("2:2") End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel vs. Long-hand accounting | Excel Discussion (Misc queries) | |||
| Grouping sheets with one hand in Excel | Excel Discussion (Misc queries) | |||
| Excel Right Hand Task Pane Shortcuts..... | Excel Discussion (Misc queries) | |||
| y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
| y-axis moves from the left hand side to the right hand side! | Charts and Charting in Excel | |||
Linear Mode
