+ Reply to Thread
Results 1 to 6 of 6

Macro to pull tasks from calendar view

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Davenport, Iowa
    MS-Off Ver
    Excel 365
    Posts
    206

    Macro to pull tasks from calendar view

    Hello,

    I have a calendar view with a list of tasks on each day, (not in an ideal setup but it's what I have to deal with) - I have a macro to extract today's data and put's it into a new sheet, then on a second sheet, list today and tomorrow's tasks. However, I can only get it to pull values, I'm looking to see if anyone can modify my script (Contained in the workbook) to pull values and formatting. Any help would be greatly appreciated
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Macro to pull tasks from calendar view

    Try
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Davenport, Iowa
    MS-Off Ver
    Excel 365
    Posts
    206

    Re: Macro to pull tasks from calendar view

    Worked great for the 1 day however, the 2 day only had 1 day's worth of data.

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to pull tasks from calendar view

    Hello
    You have said in first post
    on a second sheet, list today and tomorrow's tasks.
    Not clear at this case
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  5. #5
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Davenport, Iowa
    MS-Off Ver
    Excel 365
    Posts
    206

    Re: Macro to pull tasks from calendar view

    Now that I read again you are correct, I was able to make it work though. Thanks Jindon

    Please Login or Register  to view this content.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Macro to pull tasks from calendar view

    You are talking about the workbook other than you have uploaded, so no correct solution.
    No one can read your brain.
    Please Login or Register  to view this content.

+ 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. Map Schedule Data onto Calendar View Generated by Macro
    By howaboutno in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2016, 03:45 PM
  2. 2 spreadsheets, need to pull tasks from one to the other with 2 parameters
    By BrianKelleher in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2014, 05:53 PM
  3. Put tasks into Calendar after my module generates the Calendar
    By wrightyrx7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2014, 10:20 AM
  4. calendar with tasks for each day
    By icestationzbra in forum Excel Tips
    Replies: 0
    Last Post: 07-10-2012, 07:39 PM
  5. Automatically Create Tasks From Calendar Events
    By jesika in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 04-06-2009, 05:34 AM
  6. calendar view of tasks
    By Sue in forum Excel General
    Replies: 1
    Last Post: 03-16-2006, 08:25 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