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
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
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
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".
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
talk about stupid, omg I just figured out Moo the Dog's answer, doh!. works great thank you.
Thanks
Keith
if you attach file it is more helpful
Glad I could help, and thanks for the feedback!
- Moo
Mis-posted... nothing to see here...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks