Results 1 to 3 of 3

Please help - Moving information from one sheet to another in the same workbook

Threaded View

  1. #3
    Registered User
    Join Date
    03-12-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Please help - Moving information from one sheet to another in the same workbook

    Ok so I was messing around with the macro and cleaned it up a little bit. What I need to know is if Ican make this more generic to work with every row and not just the specified row and is there a generic code I can put in there to select the next available row to paste into on my completed tasks sheet?

    here is the cleaned up macro....
    Sub TaskCompleted()
    '
    ' TaskCompleted Macro
    '
    '
    Sheets("Task Sheet").Select
    Range("E5").Select
    Selection.Copy
    Sheets("Completed Tasks").Select
    Range("A8").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    With Selection.Interior
    .Pattern = xlSolid
    .PatternColorIndex = xlAutomatic
    .Color = 49407
    .TintAndShade = 0
    .PatternTintAndShade = 0
    End With
    Sheets("Task Sheet").Select
    Range("B5:D5").Select
    Selection.Copy
    Sheets("Completed Tasks").Select
    Range("B8:D8").Select
    ActiveSheet.Paste
    Range("A8:D8").Select
    Application.CutCopyMode = False
    With Selection.Font
    .Name = "Calibri"
    .FontStyle = "Regular"
    .Strikethrough = True
    .Superscript = False
    .Subscript = False
    .OutlineFont = False
    .Shadow = False
    .Underline = xlUnderlineStyleNone
    .TintAndShade = 0
    .ThemeFont = xlThemeFontMinor
    End With
    Sheets("Task Sheet").Select
    Range("A5:E5").Select
    Selection.ClearContents
    End Sub

    Moderator's Note: Welcome to the forum. Codes should be enclosed with code tags. Select the codes then hit the "#" symbol. Thank you for joining the community.
    Last edited by vlady; 03-14-2013 at 07:32 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1