Results 1 to 5 of 5

Thread: Calculating data from other Worksheets

  1. #1
    Junior Member
    Join Date
    Aug 2013
    Posts
    2
    Rep Power
    0

    Calculating data from other Worksheets

    Hey there,

    I have no experience with Excel programming, but with help from another person I'm close to the thing I need.

    Basically a machine sends an email with excel report once a day. Customer asked me to make excel file to calculate the monthly data, as easily as possible (for the customer).

    Currently I have a file that imports all the files in folder into one excel Workbook with lots of sheets.

    There is an empty sheet called Summary, and it has to do certain calculations but I don't know how to make it. Basically it will calculate things from other Worksheets.

    You can download the Master file and example files (I had only one, altered it a bit to get second) HERE.

    If you need any additional info, please let me know.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Aug 2013
    Posts
    2
    Rep Power
    0
    Just read the text, and will definitely think twice before xposting again. Thanks for pointing it out.

    This got solved by a member on Ozgrid.

  4. #4
    Junior Member
    Join Date
    Dec 2013
    Posts
    7
    Rep Power
    0

    crossing posting

    Does this mean if another forum did not or could not answer our question in a certain amount time we cannot try to post our problem here or another forum? I do not want to break rules but how soon is to soon to try another forum for your solutions. Thanks

  5. #5
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    Quote Originally Posted by justme1052 View Post
    Does this mean if another forum did not or could not answer our question in a certain amount time we cannot try to post our problem here or another forum? I do not want to break rules but how soon is to soon to try another forum for your solutions. Thanks
    No, you can post your questions to two forums at the same time BUT to be courteous to the volunteers you are asking to help you, you should post a message in each forum saying you also posted it at such-and-such forum and then provide a link to the first message in that other forum. This way, some one who wants to help you can see what others have suggested in that other forum so that they do not waste their time developing an answer you have already gotten elsewhere.

Similar Threads

  1. Calculating Subtotals Within Groups of Data Using UNION
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 1
    Last Post: 05-24-2013, 11:54 AM
  2. Effective way of calculating the difference
    By zzzqinzzz in forum Excel Help
    Replies: 0
    Last Post: 12-13-2012, 03:39 PM
  3. Replies: 9
    Last Post: 12-04-2012, 09:45 PM
  4. Splittting Data Into Different Worksheets Column Wise In VBA
    By rajeshd@live.in in forum Excel Help
    Replies: 1
    Last Post: 01-21-2012, 04:45 PM
  5. Splittting Data Into Different Worksheets Column Wise In VBA
    By rajeshd@live.in in forum Den Of The Fox
    Replies: 1
    Last Post: 01-21-2012, 04:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •