+ Reply to Thread
Results 1 to 13 of 13

Automatically copy data from multiple worksheets to one worksheet

  1. 06-29-2014, 01:02 AM #1
    PHUAG
    PHUAG is offline
    Registered User
    Join Date
    01-30-2010
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    20

    Automatically copy data from multiple worksheets to one worksheet

    Hi all,

    Hope you can assist. I will be manually adding data to the July 2014 - June 2015 worksheets as the months progress. Each time data is added, deleted or modified in these worksheets, I would like the Total Expenses worksheet to be populated without having to manually do a copy & paste. Is this possible? I am not sure of the number of rows that would be populated in each month.

    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-29-2014, 02:53 AM #2
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Automatically copy data from multiple worksheets to one worksheet

    Hi

    try this attached macro file and have validate
    Attached Files Attached Files
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
    Reply With QuoteRegister To Reply
  3. 06-29-2014, 03:08 AM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Automatically copy data from multiple worksheets to one worksheet

    You can do that with the code below.

    See the attached file.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  4. 06-29-2014, 03:13 AM #4
    PHUAG
    PHUAG is offline
    Registered User
    Join Date
    01-30-2010
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Automatically copy data from multiple worksheets to one worksheet

    HI Naveed,

    Each time I click on the macro, the same data is copied and therefore duplicated. If any changes were made to the existing data, I would like that to be replaced. Thanks.
    Reply With QuoteRegister To Reply
  5. 06-29-2014, 03:15 AM #5
    PHUAG
    PHUAG is offline
    Registered User
    Join Date
    01-30-2010
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Automatically copy data from multiple worksheets to one worksheet

    Hi Oeldere,

    When I changed one of the original entries in the Oct-14 tab, this was not reflected in the consolidated tab. Thank you.
    Reply With QuoteRegister To Reply
  6. 06-29-2014, 03:18 AM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Automatically copy data from multiple worksheets to one worksheet

    @Phuag

    you have to run the macro again.
    Reply With QuoteRegister To Reply
  7. 06-29-2014, 03:19 AM #7
    PHUAG
    PHUAG is offline
    Registered User
    Join Date
    01-30-2010
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Automatically copy data from multiple worksheets to one worksheet

    Oeldere, can you tell me where the macro is located? Thank you.
    Reply With QuoteRegister To Reply
  8. 06-29-2014, 03:22 AM #8
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Automatically copy data from multiple worksheets to one worksheet

    click

    Alt+F8

    Then you will find the macro

    Sub integratie_Oeldere_revisted_vs3()

    Then choose run
    Reply With QuoteRegister To Reply
  9. 06-29-2014, 03:24 AM #9
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Automatically copy data from multiple worksheets to one worksheet

    now check it out this updated file

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 06-29-2014, 03:35 AM #10
    PHUAG
    PHUAG is offline
    Registered User
    Join Date
    01-30-2010
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Automatically copy data from multiple worksheets to one worksheet

    Thank you Naveed, it is working now.
    Reply With QuoteRegister To Reply
  11. 06-29-2014, 03:36 AM #11
    PHUAG
    PHUAG is offline
    Registered User
    Join Date
    01-30-2010
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Automatically copy data from multiple worksheets to one worksheet

    Thanks Oeldere, I found it now. I didn't have the Developer ribbon in sight.
    Reply With QuoteRegister To Reply
  12. 06-29-2014, 03:40 AM #12
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Automatically copy data from multiple worksheets to one worksheet

    Glad i could help you

    thank you for reputation
    Reply With QuoteRegister To Reply
  13. 06-29-2014, 03:51 AM #13
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Automatically copy data from multiple worksheets to one worksheet

    @Phuag

    Did my solution for you?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Problem with macro to copy certain data from multiple worksheets into a summary worksheet
    By niftysquirrel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-14-2013, 03:35 PM
  2. [SOLVED] Copy multiple worksheets data & paste into blank columns in summary worksheet
    By guest99999 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-21-2013, 09:56 AM
  3. How to automatically combine data from multiple worksheets into a master worksheet
    By BeardedLuminary in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-28-2013, 10:57 AM
  4. Copy data from multiple worksheets & paste into one worksheet.
    By Rodders in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-10-2012, 11:54 AM
  5. Create copy of multiple worksheets and automatically fill in data from a main sheet
    By NMChemEng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2008, 05:28 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1