+ Reply to Thread
Results 1 to 13 of 13

Auto Populating Info from cells to a calendar by date

  1. #1
    Registered User
    Join Date
    07-27-2012
    Location
    Twin Falls
    MS-Off Ver
    Excel 2010
    Posts
    6

    Auto Populating Info from cells to a calendar by date

    Hello all,

    My name is Jason I am new to this forum and had no where else to turn for some help.

    Ok guys, I have run into a serious road block with an excel document. Heres what I am trying to do, bare with me!

    Example, and I can post the excel document if anyone needs to see it. I am creating a document for 3 shifts, within each shift, every hour my line workers have to fill out a document that contains a few different numbers and percentages, so im trying to create 8 hours, that auto populate into one sheet for their 8hr shift, x3 for 3 shifts, ive then auto populated their entire shift sheet onto a totals page, which shows each shifts totals, then auto populated the shift totals to a cell for daily totals. The problem ive run into is i want to create a calander that pulls that info by date and populates it into the calendar which then will populate it into a graph, so he can take to meeting. I have done most of the work, but i cannot figure out how to have excel populate info from one day to the next without erasing the previous days info. Is there any way to do this?

    Everything starts from the top left corner of every shift sheet which goes to shift totals, which goes to daily totals on the same page which then goes to the calendar and then the graph.

    I havend done each sheet yet for every hour, thats easy once i figure out the calendar part. Thanks for any and all help.
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Auto Populating Info from cells to a calendar by date

    Put this is a standard module.

    It copies the totals from the totals page and looks up the date and insert them into the Calendar sheet.

    You can put a commandbutton on the totals sheet to call the macro.

    Please Login or Register  to view this content.
    Last edited by Tinbendr; 07-27-2012 at 10:45 PM.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    07-27-2012
    Location
    Twin Falls
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Auto Populating Info from cells to a calendar by date

    Will this formula keep the information day to day or will it erase the previous days info, once a new date is typed in?

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Auto Populating Info from cells to a calendar by date

    If you run it the same day, it will overwrite that day's value in the calendar. Otherwise, it looks up the date from the Totals page and inserts the totals onto the Calendar page.

  5. #5
    Registered User
    Join Date
    07-27-2012
    Location
    Twin Falls
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Auto Populating Info from cells to a calendar by date

    Yeah I understand that if I run the that twice in the same day it will overwrite anything that was previously input, but, will say toay i use that code, and it fills in todays date, at the end of the day i save my doc. and then tomorrow run it again. Will the code erase yesterdays data out of the calender, or will it keep yesterdays date and continuously update day to day.

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Auto Populating Info from cells to a calendar by date

    Whatever date is in 'Shift Totals'!H25, then it will only post the data to that day.

  7. #7
    Registered User
    Join Date
    07-27-2012
    Location
    Twin Falls
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Auto Populating Info from cells to a calendar by date

    I plugged in that code, but when i run the macro it states, run-time error '9' subscript out of range.

  8. #8
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Auto Populating Info from cells to a calendar by date

    Sheet name Calendar is misspelled. I had corrected it on my Sheet.

    Just change the code to the Sheet spelling.

    (That's my OCD kicking in.)

  9. #9
    Registered User
    Join Date
    07-27-2012
    Location
    Twin Falls
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Auto Populating Info from cells to a calendar by date

    Yeah ended up figuring it out. That formula is pretty amazing, how/where did you learn how to do that?

  10. #10
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Auto Populating Info from cells to a calendar by date

    Quote Originally Posted by mitchellm203 View Post
    how/where did you learn how to do that?
    Started with Excel 97. I needed to figure out a problem. Bought a book. Studied the forums. The rest is history.

  11. #11
    Registered User
    Join Date
    07-27-2012
    Location
    Twin Falls
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Auto Populating Info from cells to a calendar by date

    Well I appreciate it, i had been stumped on that for about 2 days pulling my hair out trying everything i knew how to get the info to populate without erasing prior days info, works great. Once again i really appreciate the help. The last class i took was back in 2000, and i typically up until my new job never used excel that much other than for basic spreadsheets.

    ---------- Post added at 06:14 PM ---------- Previous post was at 05:14 PM ----------

    You know anything about auto populating graphs from a calendar, ive been searching youtube, but nothing really great on there.

  12. #12
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Auto Populating Info from cells to a calendar by date

    @ mitchellm203

    Based on your last posts it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.



    Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  13. #13
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Auto Populating Info from cells to a calendar by date

    Quote Originally Posted by mitchellm203 View Post
    You know anything about auto populating graphs from a calendar,
    I do not. I have only recorded a few macros while adding a graph.

    But as Cutter has indicated, you're original question has been answered. If you have another question about a graph, start a new message.

    Good luck!

    David

+ 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