+ Reply to Thread
Results 1 to 2 of 2

Macro - To copy rows from multiple sheets to one sheet

  1. #1
    Registered User
    Join Date
    02-19-2019
    Location
    England
    MS-Off Ver
    2016
    Posts
    3

    Macro - To copy rows from multiple sheets to one sheet

    Hi,

    Would someone be able to help me with a macro please. I am looking for one to do the following:

    I have a capacity planning spreadsheet with 14 sheets. 9 of the sheets are individual timing/task plan sheets for each member of the team. So apart from the data they have input into them the table/headings are the same. The first row where they will input data is no. 21 and the columns run from C to P.

    I would like to copy all the data from each sheet into 1 sheet (Master Timing Plan) so I can see all tasks at once. And I want this to be updated every time they add/amend something on their timing plan.

    Thank you

    SB

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Macro - To copy rows from multiple sheets to one sheet

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.

    -



    See clip
    To add a file to a post

+ 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. Copy rows from multiple sheets paste to new sheet
    By cindywylie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-14-2017, 04:06 PM
  2. Copy Rows from multiple sheets in to single sheet
    By Hblbs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2017, 09:56 AM
  3. Copy rows in multiple sheets given a critieria and merge them in another sheet
    By on2mars in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2014, 06:27 AM
  4. [SOLVED] Copy Rows to sheet if column value >40, multiple sheets
    By rlowe in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-04-2013, 06:08 PM
  5. Search for Multiple String Values on Multiple Sheets and Copy Rows to New Sheet
    By rrtikker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 12:21 PM
  6. Replies: 1
    Last Post: 07-29-2011, 05:03 AM
  7. copy rows from 1 sheet to multiple sheets
    By GatorHunter in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2010, 08:26 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