+ Reply to Thread
Results 1 to 2 of 2

how to place auto summary of cells of excel sheets into another sheet/work book?

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    Northern England
    MS-Off Ver
    2010
    Posts
    1

    how to place auto summary of cells of excel sheets into another sheet/work book?

    Hi
    New here and self taught on excel so bear with me please.

    I have set up a master 'jobsheet' for our business in an excel work book, I then copy and paste this sheet into a new sheet in the work book and rename it as a customer and date. Into these sheets I can put basic info such as date, invoice number, customer name etc as well as more detailed data such as materials used, special requests, formulae driven costings etc. Every new job gets a new worksheet.

    I would like to automatically take a summary into another sheet or workbook of all of these sheets as they are generated for new customers, taken from the same cells from each sheet i.e. date from each sheet, customer name from each sheet, etc etc (hope that makes sense)..... this data to appear in the 'summary sheet' maybe five cells wide running in columns down the summary sheet.

    Q. Is it possible?
    Is it difficult?
    How would I do it?

    Thanks in anticipation

    Eco

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,257

    Re: how to place auto summary of cells of excel sheets into another sheet/work book?

    A macro would do it - I hope you can modify it to meet your needs. Run the macro anytime to update the Summary sheet.

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Creating auto populating Summary sheet as new sheets are added to work book
    By Phraedrique in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2012, 05:01 PM
  2. [SOLVED] To sum up the many work sheets total on a summary sheet
    By PRADEEPB270 in forum Excel General
    Replies: 1
    Last Post: 05-24-2010, 06:04 AM
  3. Replies: 0
    Last Post: 12-14-2005, 01:53 PM
  4. [SOLVED] auto numbering an exel work book sheet everytime it opens or print
    By Rugby Al in forum Excel General
    Replies: 1
    Last Post: 07-19-2005, 02:05 PM
  5. Replies: 2
    Last Post: 04-20-2005, 09:06 PM

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