okay so i a have a bunch of random information on one sheet, i have created a macro that copies the information i want and pastes it into row 1 of an alternate sheet.
When i open another sheet and perform my macro again it will overwrite this information onto row 1 of my alternate sheet making me lose all my previous information. what i am looking to do is have my macro switch to row 2 when row 1 has information then row 3 when row 2 has information and so on.
Sub export_deviation()
'
' export_deviation Macro
' Macro recorded 12/20/2007 by Matt_s
'
' Keyboard Shortcut: Ctrl+d
'
Range("C11:CN11").Select
Selection.Copy
ActiveWindow.WindowState = xlMinimized
Windows("CAPDUMP.xls").Activate
ActiveWindow.WindowState = xlMaximized
Range("B1").Select
ActiveSheet.Paste
Range("B2").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = ""
Range("M8").Select
End Sub
is my current macro. any help would be appreciated, thanks!
Bookmarks