+ Reply to Thread
Results 1 to 2 of 2

Copy cell A3 and Cell A5 of numerous sheets into a single sheet

Hybrid View

aarona Copy cell A3 and Cell A5 of... 05-06-2017, 01:43 AM
aarona Re: Copy cell A3 and Cell A5... 05-06-2017, 01:56 AM
  1. #1
    Forum Contributor
    Join Date
    06-07-2016
    Location
    Manila
    MS-Off Ver
    365
    Posts
    292

    Copy cell A3 and Cell A5 of numerous sheets into a single sheet

    Hi All,

    Need your help again.

    Scenario:

    I have a master excel file with 100+ sheets on it. What I need from macro is to automatically get all data of cell A3 and cell A5 of sheets 4 to end

    Then, I want macro to paste all the data from all sheets (4 to end) to the sheet(3) (or third sheet from the start) and paste all the corresponding values of cell A3 and cell A5 of the sheets 4 to end (I want macro to paste the value in sheet 3 Cell A and B)

    Is this possible?

    Thank you.

  2. #2
    Forum Contributor
    Join Date
    06-07-2016
    Location
    Manila
    MS-Off Ver
    365
    Posts
    292

    Re: Copy cell A3 and Cell A5 of numerous sheets into a single sheet

    nvm, was able to solved it with this.

    
    Dim sh As Worksheet
    
    For Each sh In ActiveWorkbook.Worksheets
    
    If sh.Index > 3 Then
        sh.Range("A3").Copy
        Worksheets("Summary").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues
        sh.Range("A5").Copy
        
    Worksheets("Summary").Range("B" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues
    End If
    
    Next

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. accessing sheets from a single cell in matster sheet
    By LLOYD6664 in forum Excel General
    Replies: 1
    Last Post: 11-24-2016, 08:45 PM
  2. Replies: 3
    Last Post: 04-03-2014, 08:14 PM
  3. Replies: 15
    Last Post: 01-24-2014, 06:32 PM
  4. [SOLVED] Code to copy numerous sheet cell ranges to a word document on my desktop
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 07:48 PM
  5. [SOLVED] Pull data from a single Cell in many diffrent sheets to the summary sheet
    By iancghln in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2012, 02:24 PM
  6. Copy+Paste Special Single Cell on all sheets
    By eg1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-23-2011, 01:30 PM
  7. Text formatting: from single cell to numerous cells
    By jeff.p in forum Excel General
    Replies: 3
    Last Post: 12-18-2007, 11:43 AM

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