Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Macro to copy

I have a sheet that comrpise TWO blocks of data
Block A goes from A1 to g20 displays chores that HAVE been done
Block B goes from A100 to G130 displays chores that HAVE TO BE DONE
Once a chore is done I want to select that line in block B and have a
macro copy that line to the bottom of block A above
I would appreciate any help you can give me
thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 420
Default Macro to copy

You could add a button from the Forms toolbar (or use a shortcut key or even
Alt-F8) to run a macro that copies the cell with the activecell on it:

Option Explicit
Sub testme()

Dim NextRow As Long

With ActiveSheet

'after the end of the first group, but before the start
'of the second. I used row 88.
NextRow = .Cells(88, "A").End(xlUp).Row + 1

'some minor checks
If ActiveCell.Row < 100 Then
Beep
'or give a message
MsgBox "Move to the second group!"
Else
ActiveCell.EntireRow.Copy _
Destination:=.Cells(NextRow, "A")
End If
End With
End Sub


If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)


On 07/23/2010 09:26, wrote:
I have a sheet that comrpise TWO blocks of data
Block A goes from A1 to g20 displays chores that HAVE been done
Block B goes from A100 to G130 displays chores that HAVE TO BE DONE
Once a chore is done I want to select that line in block B and have a
macro copy that line to the bottom of block A above
I would appreciate any help you can give me
thanks


--
Dave Peterson
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
Change a Macro - Copy in Columns instead of copy in Rows ytayta555 Excel Programming 7 May 9th 09 06:32 PM
Copy workbook, don't copy macro CongroGrey Excel Discussion (Misc queries) 1 June 13th 08 04:56 PM
Macro to copy and paste values (columns)I have a macro file built C02C04 Excel Programming 2 May 2nd 08 01:51 PM
how to count/sum by function/macro to get the number of record to do copy/paste in macro tango Excel Programming 1 October 15th 04 01:16 PM


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

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

About Us

"It's about Microsoft Excel"