+ Reply to Thread
Results 1 to 3 of 3

Creating report to run by date and pull info from other sheets to master sheet in one book

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    Kalamazoo, MI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Creating report to run by date and pull info from other sheets to master sheet in one book

    Hello!
    I am creating an excel workbook that has 4 sheets. I want to be able to pull/run the information on the "Report" sheet by date according to what is listed in the other 3 worksheets. I also want all of the listed info to appear in each chart on the "Report" sheet according to what is listed in the other worksheets under that specific date.

    Does that make sense? The excel workbook is attached.

    Thanks!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Creating report to run by date and pull info from other sheets to master sheet in one

    This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

    Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

    Have you started any work on this project yet?
    How far did you get?
    Where are you stuck?

    We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    12-03-2012
    Location
    Kalamazoo, MI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Creating report to run by date and pull info from other sheets to master sheet in one

    Thanks for your response! I guess I don't know where to start. So I would greatly appreciate your help.

    I tried to insert a formula that says if the date (on the "reports" sheet) = the date (on the Awaken sheet) then the appropriate name would pop up in the column. ButI don't know how that would work with the entire workbook because it would refer to the specific date on the Awaken sheet and I need it to refer to many different dates.

    What would you suggest my next step be?
    Thank you!!

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1