+ Reply to Thread
Results 1 to 6 of 6

VBA to find date in a row and write name that is associated with date to a calendar

  1. #1
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    VBA to find date in a row and write name that is associated with date to a calendar

    It's been a while since I've last participated with you guys/gals here in the forum. Our company has downsized and I lost my right hand gal who kept up with my Employee files for me.

    Attached is a small sample xls file(I removed actual names and info) to give you an idea what I'm trying to accomplish. I created this file years and years ago and it has done it's job, but I'm trying to spiffy it up now that my right hand is gone.

    Task at hand is trying to enter dates as the employees request vacation on Worksheet "Input Data Vac 13" and get VBA to automatically write the employee's 1st and Last name over in the Calendar on Worksheet "2013 Vac Calendar".

    I'm currently stuck in trying to come up with a way to perform this task.
    Any guidance or push from the forum members to find a solution will be greatly appreciated.


    *EDIT*
    New Employee Workbook example attached to post#6
    I revised the layout in the calendar and eliminated the merged cells to make it more VBA friendly...and added VBA code.
    Attached Files Attached Files
    Last edited by jwright650; 04-05-2013 at 09:24 AM. Reason: pointing readers to new workbook in post#6
    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright

  2. #2
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: VBA to find date in a row and write name that is associated with date to a calendar

    Forgot to mention and my profile doesn't reflect this:
    Excel 2007 currently in use on this computer.

    Just trying to get my VBA thought processes flowing again

  3. #3
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: VBA to find date in a row and write name that is associated with date to a calendar

    I'm just stuck as to where to start building this. I may need help with getting my script/code to run at some point, but right now I'm stuck in the design stages, so if someone can point out a method of attack, that would be very helpful. I just don't know how to get started at the moment because there are several ways to do this. I used a free demo calendar and edited it to work for my plant manager, but maybe what I have isn't ideal to write code for...IDK.

    I have a "few" VBA skills, but they are rusty. I keep reading in the forum and a few things are coming back to me. Man if you don't use this stuff regularly, you can lose the methodical thought process of how to get going. Plus I'm getting old and forgetfull...LOL
    Thanks guys/gals....I see a few views on the thread, so I appreciate you all who are looking in on my thread.

  4. #4
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: VBA to find date in a row and write name that is associated with date to a calendar

    I'm thinking about adding a clickable object to the calendar worksheet and use that to click to update the calendar once I've added dates to the input data vac 13 worksheet. Currently trying to remember how to write a macro to make this clickable and loop through the cells on one worksheet and copy to the calendar worksheet.

  5. #5
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: VBA to find date in a row and write name that is associated with date to a calendar

    Got it...Thanks for the help.

  6. #6
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: VBA to find date in a row and write name that is associated with date to a calendar

    Thought I would add my new "example file" with the code in it in case a newcomer may be able to use this and edit it for their own use. If someone sees something in this code that can be done a better, more efficient way, don't mind speaking up...I'm still very new at this VBA stuff and still do mostly trial and error work...LOL
    Attached Files Attached Files

+ 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