+ Reply to Thread
Results 1 to 4 of 4

Help taking the monthly values of a employee master sheet and paste into separate sheet

  1. #1
    Registered User
    Join Date
    08-13-2009
    Location
    Glasgow
    MS-Off Ver
    Excel 2016,2016,365
    Posts
    92

    Help taking the monthly values of a employee master sheet and paste into separate sheet

    Hello

    Appreciate all the help on here recently, learning loads. Stuck today.

    On Sheet -Compensation I want to take the monthly values for each employee and paste into their own separate sheet.

    Compensation has 4 columns
    Employee ID, Name, Month, Cost

    and I have a sheet for each employee with just the month and cost brought over from the compensation sheet.

    Not sure if I need a loop statement?
    See attached.

    Thanks

    Ross
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,024

    Re: Help taking the monthly values of a employee master sheet and paste into separate shee

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    08-13-2009
    Location
    Glasgow
    MS-Off Ver
    Excel 2016,2016,365
    Posts
    92

    Re: Help taking the monthly values of a employee master sheet and paste into separate shee

    Thanks V Much

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,024

    Re: Help taking the monthly values of a employee master sheet and paste into separate shee

    My pleasure.

+ 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. Taking data from different excel sheet in one Master sheet
    By Dost.Rehman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2017, 02:45 AM
  2. [SOLVED] Macro to export each sheet after Master Sheet as separate workbook including Master
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-02-2017, 09:06 AM
  3. Replies: 1
    Last Post: 09-15-2014, 01:03 PM
  4. How to transfer data from a daily input sheet to a separate monthly total sheet
    By Jcooper71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2014, 02:37 PM
  5. Updating master sheet with monthly results on other sheet within same workbook
    By aghoba in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-03-2011, 08:39 PM
  6. Replies: 9
    Last Post: 04-04-2011, 12:03 AM
  7. Transferring from one ''Annual'' sheet to separate ''Monthly'' sheet and reverse
    By crehan57 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2010, 09:39 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