Results 1 to 4 of 4

For next sheet +1

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    Durham
    MS-Off Ver
    Excel 2003
    Posts
    61

    For next sheet +1

    Hi

    I have one big sheet, one summary page, which is to be a summary journal of all the other area managers journals

    I have basic bits done but I am stuck flicking from the managers journal, then pasting it to the summary, then going to the next managers journal sheet.

    the summary sheet is on sheet(3) or "Summary Journal", the managers journals are from sheets(5) and above.

    The amount of managers change every month and I have to sumif their data, which I have already done.

    I need to flick from sheets(5) to the "Summary Journal", do my stuff, then to sheets(6), then to the "Summary Journal", then Sheets(7) and so on

    Im assuming I need to, when on Sheets(5) I need to dim the sh = sh+1 or something like that
    Dim sh As Worksheet
        Dim wb As Workbook
        
        
    
        For Each sh In ActiveWorkbook.Worksheets
            With sh
                Sheets(5).Select
    
    
        Range("N5:T5").Select ' this is just pasting my workings etc
        Range(Selection, Selection.End(xlDown)).Select
        Selection.Copy
        Sheets("Summary Journal").Select
        Range("A2").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
    
            
        sh = sh + 1 ' my problem area
    
        End With
        Next sh
    Last edited by cooket4; 05-14-2014 at 07:50 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup Value from Sheet 4 in Sheet 2, if found copy Sheet 2 Active Row to Sheet 5
    By lgosso23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2013, 02:51 PM
  2. [SOLVED] Match Value in Sheet 1 with Sheet 2, copy entire row from sheet 1 to new sheet
    By lzyshaman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2013, 07:48 AM
  3. [SOLVED] find code# from sheet 1 on sheet 2, compare value on sheet 1 with value on sheet 2
    By BlakeLee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-27-2013, 01:52 PM
  4. Replies: 11
    Last Post: 10-14-2012, 01:03 PM
  5. Replies: 2
    Last Post: 10-12-2010, 05:00 PM

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