+ Reply to Thread
Results 1 to 8 of 8

date picker into multiple cells

  1. #1
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Racine, wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    225

    date picker into multiple cells

    is there a way to use Microsoft date and time picker control 6.0 sp4, when you pick the date, it will load cells
    A1,C1,E1 and G1 on sheet4, all at the same time, I want to be able to pick the dates 2 to 5 days ahead.

    Thanks
    Keith

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: date picker into multiple cells

    Not sure exactly what you are asking, but if the date only gets placed in the active cell, say A1, couldn't you simply add: =A1 to C1, E1 and G1, so they all contain the same value?

    -Moo

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: date picker into multiple cells

    Did you mean if one sheet date is enter in another sheet then first sheet relevant data automatically pull in another sheet.
    If this is correct, then you are using with index match formula accordingly to range.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Racine, wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: date picker into multiple cells

    All the data will be on sheet4 of the workbook, cell a1,c1,e1 and g1 is where I would like to choose a date from the calendar instead of copying and pasting
    the dates into the other 3 cells, because cell b1,d1,f1 and h1 have a name in the cell of 4 different people, and cells below them are their tasks for the day.
    could be anywhere from 1 to 20 tasks for them, but its all on 1 sheet, and then gets printed and cut up into 4 pieces and they go on their own way after getting their piece of paper, which is their assignment. all their tasks are choose by 1 click so far, and if possible I would like to do a 1 click set date and time, then print and give it to their boss to cut up and hand out.

    Thanks
    Keith

  5. #5
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Racine, wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: date picker into multiple cells

    talk about stupid, omg I just figured out Moo the Dog's answer, doh!. works great thank you.

    Thanks
    Keith

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: date picker into multiple cells

    if you attach file it is more helpful

  7. #7
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: date picker into multiple cells

    Glad I could help, and thanks for the feedback!

    - Moo

  8. #8
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: date picker into multiple cells

    Mis-posted... nothing to see here...

+ 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. Add Date to User Form Without Access to Add Date Picker Control
    By kaleonard08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2016, 12:06 PM
  2. Date picker used to populate text box. Date changes back to original value on opening.
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2016, 09:42 AM
  3. [SOLVED] file-picker thinks it is a folder-picker if the folder picker runs first?
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2016, 01:14 PM
  4. Replies: 0
    Last Post: 08-01-2015, 12:29 AM
  5. Add date picker to multiple cells
    By junada0 in forum Excel General
    Replies: 0
    Last Post: 02-19-2013, 02:19 PM
  6. [SOLVED] How can I insert a drop down date picker to worksheet cells?
    By ron in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2005, 01:55 PM
  7. [SOLVED] How can I insert a drop down date picker to worksheet cells?
    By ron in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2005, 01:45 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