Results 1 to 17 of 17

Transferring data from several worksheets to one "summary" worksheet in the same workbook

Threaded View

smasian Transferring data from... 08-27-2013, 03:46 PM
Dimitrov Re: Transferring data from... 08-27-2013, 03:59 PM
alansidman Re: Transferring data from... 08-27-2013, 04:01 PM
oeldere Re: Transferring data from... 08-27-2013, 05:44 PM
smasian Re: Transferring data from... 08-27-2013, 07:19 PM
oeldere Re: Transferring data from... 08-28-2013, 07:15 AM
smasian Re: Transferring data from... 08-28-2013, 02:58 PM
oeldere Re: Transferring data from... 08-28-2013, 03:12 PM
smasian Re: Transferring data from... 08-28-2013, 08:34 PM
smasian Re: Transferring data from... 08-28-2013, 08:33 PM
oeldere Re: Transferring data from... 08-29-2013, 06:51 AM
smasian Re: Transferring data from... 08-29-2013, 07:07 PM
oeldere Re: Transferring data from... 08-30-2013, 07:26 AM
smasian Re: Transferring data from... 08-30-2013, 11:34 AM
AB33 Re: Transferring data from... 08-30-2013, 11:49 AM
smasian Re: Transferring data from... 08-30-2013, 12:31 PM
oeldere Re: Transferring data from... 08-30-2013, 12:43 PM
  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2002
    Posts
    14

    Transferring data from several worksheets to one "summary" worksheet in the same workbook

    Hi,

    My company is implementing new pay plans for our employees. I have created a workbook where each employee will have a worksheet that will automatically calculate how much they will be paid for each pay period. However, for internal purposes, we would like to have some of the fields transferred to another "summary" worksheet.

    I have attached a sample. I would like to have the green highlighted portion from each of the worksheets transferred to the worksheet titled "Payroll Sheet".

    I have been reading up on VBA and Macros, but I am not too familiar with it still.

    Could someone please help me with this?

    Thank you in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run Macros on all except "Summary" and "Reports" worksheets in a workbook
    By daralea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2013, 05:42 PM
  2. [SOLVED] 2 workbooks transferring cell data from workbook1 to workbook 2 (when cell has "art" in it
    By garfield8626 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2013, 02:36 PM
  3. [SOLVED] Need Macro to compile data from "Weekly" sheets and sum up into "Monthly" summary sheet
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2013, 07:25 PM
  4. [SOLVED] Consolidating "Select Worksheets" in a Workbook into a Consolidated Worksheet
    By tecmkr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2012, 12:53 PM
  5. [SOLVED] Transferring date from multiple worksheets to a "totals" worksheet.
    By tonyDeBrasco in forum Excel General
    Replies: 3
    Last Post: 07-22-2005, 01:05 PM

Tags for this Thread

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