+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Forum Contributor
    Join Date
    06-07-2016
    Location
    Manila
    MS-Off Ver
    2016
    Posts
    267

    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
    2016
    Posts
    267

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

    nvm, was able to solved it with this.

    Please Login or Register  to view this content.

+ 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