Results 1 to 8 of 8

Data Compile

Threaded View

rizmomin Sum Data and Copy/Paste 02-07-2008, 03:26 PM
Leith Ross Hello Riz, I have been... 02-07-2008, 07:59 PM
rizmomin No i did not have any... 02-08-2008, 12:08 AM
rylo Riz Don't need macros for... 02-08-2008, 12:58 AM
rizmomin Thank you very much ..this... 02-08-2008, 12:29 PM
  1. 02-07-2008, 03:26 PM #1
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Sum Data and Copy/Paste

    Attach is the excel sheet for referance.

    Data Sheet contains all required data.

    Need Macros as follows

    Macro#1
    Needs to use data from "Data" Sheet and compile in Monthly summary sheet as follows.
    Eg : Sum of all Count65 column(D) for Jan 07 from "Data" sheet and enter in at B5 in Montly Summary Sheet.
    Sum of all Sales Commission column for Jan 07 from "Data" Sheet and enter at C5 in Monthly Summary Sheet.
    Similary for column D,E,F,G


    Macro#2 needs to use data from "Data" Sheet and compile as in Clinic_Monthly summary sheet.

    EXactly as in Macro 1 above and inthe format shown in Clinic_Monthly Summary Sheet...


    Help is always aprreciated...

    Please let me know if you have any questions..

    Thank You in advance

    Riz Momin
    Attached Files Attached Files
    Last edited by rizmomin; 02-07-2008 at 05:06 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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