+ Reply to Thread
Results 1 to 2 of 2

Macro copy data range from individual worksheets to new rows in consolidated worksheet

  1. #1
    Registered User
    Join Date
    07-19-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Macro copy data range from individual worksheets to new rows in consolidated worksheet

    I am designing a workbook to consolidate my staff claims based on their travel and entertainment expenditure.

    I would like them to key-in their monthly expenditure in their individual worksheets ("Tom", "****" and "Harry") - if there were any travel- or accommodation-related details, to provide further details. If there is more than one incidence of travel/accommodation, they can click the "Add More" macro button to fill-in the relevant details.

    What I would like to happen after they are done with their monthly claims is to click on another button - titled "Post" - to have their details posted to the "Consolidated" worksheet.

    I have provided an example of the envisaged outcome in the attached spreadsheet titled "Example".

    Appreciate your help on the code to effect the "Post" button. Thanks.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-19-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Macro copy data range from individual worksheets to new rows in consolidated worksheet

    Appreciate any help at all

+ 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. Macro to Copy multiple worksheets into a consolidated file
    By Crossy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-11-2013, 02:35 AM
  2. [SOLVED] Macro to copy filtered rows into new individual worksheets. Runtime Error 1004- line 25
    By J_Lee_M in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-23-2013, 01:27 AM
  3. [SOLVED] Excel macro to search a particular workbook and copy data to consolidated
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2013, 10:34 AM
  4. Separate Data from Master Worksheet into Individual Worksheets
    By bhenderson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2011, 02:14 PM
  5. copy rows from master worksheet to individual worksheets by cell value???
    By whittace in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-01-2010, 10:49 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