Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 17th 22, 07:59 PM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2022
Posts: 2
Default 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   Report Post  
Old February 17th 22, 09:17 PM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2022
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel vs. Long-hand accounting Michelle Boatwright Excel Discussion (Misc queries) 2 August 30th 06 04:42 AM
Grouping sheets with one hand in Excel Steve Vincent Excel Discussion (Misc queries) 2 April 5th 06 07:25 PM
Excel Right Hand Task Pane Shortcuts..... Dermot Excel Discussion (Misc queries) 0 February 23rd 06 10:30 PM
y-axis moves from the left hand side to the right hand side JP Excel Discussion (Misc queries) 1 March 13th 05 05:43 PM
y-axis moves from the left hand side to the right hand side! JP Charts and Charting in Excel 1 March 11th 05 01:29 AM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017