LinkBack URL
About LinkBacks
Hi
I am working on the project to schedule home visits. I have been trying to populate datails in Worksheet (NextVisit) into Calendar but to no avail.
Attached my worksheet for your kind assistance.
Thanks and regards
Attachment 151725
Hi
I am working on the project to schedule home visits. I have been trying to populate datails in Worksheet (NextVisit) into Calendar but to no avail.
Attached my worksheet for your kind assistance.
Thanks and regards
Attachment 151725
hi,
no need to double post!
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Sorry. I do not know how to delete the duplicate.
Nancy
In my opinion the most important thing is to make sure that you use proper dates, not use text like Monday, this should be a date formatted as "mmmm"
Then you can use Lookup functions to populate events.
I've posted xamples here of you search
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi
Noted with thanks.
Please help me with the Vlookup function.
Regards
Nancy
Hi
Can anyone help me with this function with cant work.
IF(ISERROR(VLOOKUP(E3,NextVisit!$A$3:$B$27,1,FALSE)),"",VLOOKUP(E3,NextVisit!$A$3:$B$27,1,FALSE))
Thanks and regards
Nancy
Hi try this it should help you
Demo Calendar.xls
Toonies
How do you expect VLOOKUP to work? The lookup value is a number, there's no numbes in the leftmost column of the data,
Hi Nancy,Originally Posted by nancyching1711
I've amended one of my calendar files to suit your requirements. I just need to amend some conditional formatting in the file, so I'll post it later.
Pete
Hi Nancy,
file is attached. Enter details of your visits in columns B to D of the Visits sheet in any order - you can hide column A if you wish, as this contains a formula copied down to row 1000. On the Calendar sheet you can select the month and year of interest using the drop-downs in cells Z4 and Z5, and the display will automatically adjust, showing up to 7 activities per day. All done by formulae, so no need for VBA on this one.
Hope this helps.
Pete
Thanks Pete. That's a great spreadsheet.
Nancy
Thank you - worked great!!!
Hi Pete,
Came across your name again in related post. I would like to attach the spreadsheet I created. Look at Sheet2. Enter date into Site Visit Day 1 (A) and it auto-generates the other dates. Is there a way to link this spreadsheet to a calendar as well as the column headings as the activity?
Thanks,
Susan
SKSS,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks