1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Copy Comments Macro/Forulma

Discussion in 'Business Applications' started by seedub, Nov 5, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. seedub

    seedub Thread Starter

    Joined:
    Oct 29, 2007
    Messages:
    10
    Here is a sample of a vacation tracker that i have been creating for our site. It is setup in the way it is for our business needs. There is more that will be added to it in the days to come, but i hit a snag with what i am doing.

    on the period 1-6 tab all the information is linked to the Employee Information tab. With the people that will be using this file i want to be able to lock out the ENTIRE period 1-6 tab from any type of editing, so no one can mess up formulas, ect. But the biggest problem is when someone takes a day off it can be for many different reasons, not just a vacation day, so a comment is added specifying what it is for (on the Employee information tab).

    Now time for my question... Is there a macro that could be built, or an addition to my formula.. Everywhere there is a "1" in the Period 1-6 tab i want it to find the relative cell in the Employee Information tab and copy the comment to that cell.
    If its something as easy as changing the formula around to add that in that would be best. but if not is there a macro that could be run everytime the workbook opens to do this?

    Hopefully i am clear on what i need, and someone can point me in the right direction.

    Thanks
     

    Attached Files:

  2. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Hi there, welcome to the board!

    Personally I think this is something that needs to be in Access. Do you have the ability to use that application? If not, you might want to think about using OpenOffice or some other database application. Everything you're asking in an inherent ability of Access, whereas we'd need to manually create what you're wanting to do in Excel. Plus it has a great dashboard utility and an easy way to set user rights and login details.
     
  3. seedub

    seedub Thread Starter

    Joined:
    Oct 29, 2007
    Messages:
    10
    I was thinkin about that. I do know a fair amount of access, just not a fan of building them.. but here we go.. thanks for the advise
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    seedub, do you want some assistance with the Access version?
     
  5. seedub

    seedub Thread Starter

    Joined:
    Oct 29, 2007
    Messages:
    10
    Ill always take assistance :cool: I am not the best at access but i might be able to pull it off
     
  6. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    What version of Access do you have?
     
  7. seedub

    seedub Thread Starter

    Joined:
    Oct 29, 2007
    Messages:
    10
    2002 Sp3
     
  8. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    OBP, I had started something real basic but got called away and never got far with it. However, I am here too,k so if you want to post a starter, I'll pitch in (not that you need it, but so you can go get some tea or something!) :)
     
  9. seedub

    seedub Thread Starter

    Joined:
    Oct 29, 2007
    Messages:
    10
    lmao... this board is awesome!
     
  10. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    seedub, have a look at this Access version and see what you think.
     

    Attached Files:

  11. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    By the way, it is not finished, I just want to see if you can live with an Access version.
     
  12. seedub

    seedub Thread Starter

    Joined:
    Oct 29, 2007
    Messages:
    10
    Ya, i have went to all my superior bosses, and explained to them about Access. I have no problems using it. I do have some knowledge in access, but more so in making Queries and Forms and reports, not so much in making the tables, and linking them properly with all the validation rules,... blah blah blah.. haha

    This place is notorious for using Excel spreadsheets as database replacements, i am going to stear them in the right direction, until i came along there was NOONE in this building that knows anything about access, so its now my job to build a bunch of databases.. Time to do some studying.

    Going to play around with what you have posted, just to see how it all works, and get ideas on the actual creation of the database.

    But so far it looks great!
     
  13. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/648233

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice