Results 1 to 4 of 4

Copy paste Macro, Finding a specific value.

Threaded View

itsnick Copy paste Macro, Finding a... 10-28-2009, 01:34 PM
JBeaucaire Re: Copy paste Macro, Finding... 10-28-2009, 02:00 PM
itsnick Re: Copy paste Macro, Finding... 10-28-2009, 02:17 PM
itsnick Re: Copy paste Macro, Finding... 10-28-2009, 03:53 PM
  1. #1
    Registered User
    Join Date
    07-16-2008
    Location
    SF
    Posts
    61

    Copy paste Macro, Finding a specific value.

    This Macro is supposed to get certain totals for me from diffrent pages. Instead of selecting an entire row I want to select specific cells, so when it finds the word total on the sheet, whose location can change often it will return the value two cells away. How can I change this code below ?


    Sub GetTotals()
    '
    ' GetTotals Macro
    '
        'NEW sheet
        Sheets("NEW").Select
    
        Cells.Find(What:="Total", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
            :=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext).Activate
        ActiveCell.EntireRow.Select
        Selection.Copy
        Sheets("Summary").Select
        Range("A2").Select
        Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
            xlNone, SkipBlanks:=False, Transpose:=False
            Application.CutCopyMode = False
    
    
    
    
    End Sub
    Last edited by itsnick; 10-29-2009 at 09:08 AM.

Thread Information

Users Browsing this Thread

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

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