Results 1 to 7 of 7

Store summary calculations for each worksheet in a single worksheet

Threaded View

rgilpatric Store summary calculations... 11-04-2012, 02:24 PM
rgilpatric Re: Store summary... 11-04-2012, 03:16 PM
rgilpatric Re: Store summary... 11-04-2012, 05:12 PM
rgilpatric Re: Store summary... 11-04-2012, 05:10 PM
rgilpatric Re: Store summary... 11-05-2012, 01:21 PM
rgilpatric Re: Store summary... 11-05-2012, 06:08 PM
rgilpatric Re: Store summary... 11-07-2012, 04:45 PM
  1. #1
    Registered User
    Join Date
    09-03-2012
    Location
    Virginia
    MS-Off Ver
    excel 2010
    Posts
    18

    Store summary calculations for each worksheet in a single worksheet

    Hi. I have a workbook with many worksheets as follows:

    Summary Calculations aapl goog msft....etc

    The Calculations sheet does all the calculations but only on one stock at a time.
    So I am hoping for a macro that does the following:

    1. Calculations Sheet: Clears all data in columns A through E
    2. 1st sheet to right of Calculations sheet: Copies all data in columns A through E and paste into Calculations Sheet (A through E).
    3. Summary Sheet: Store results of calculations sheet (H1 through Q1) in (B2 through J2) of summary sheet.
    4. Summary Sheet: Store Sheet name into first cell of row on summary sheet. (B1 for first run)
    5. Loop through remaining sheets storing the calculations each time into the next open row on the summary sheet.

    Thank you for any help you can give me.
    Attached Files Attached Files
    Last edited by rgilpatric; 11-04-2012 at 03:14 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1