Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Benaway
  • Content: Threads
  • Order by date
  1. Benaway

    Macro needed

    I have 2 workbooks. I need a macro that when activated in workbook1, it will take you to workbook2 with its own path in a [highlight #FCE94F]NEW instance[/highlight] and at the same time will close and save workbook1.
  2. Benaway

    System Time correction

    Our computers are controlled by a central server on pacific time which is lock down and we can not change. . We are on central time which is a one hour difference. When we make spread sheets in excel, is always looks at the system time to calculate dates and time, which are incorrect for our...
  3. Benaway

    Macro to reset dropdown at a given system time

    I currently have a spreadsheet that is used as a check in/out board at work. Attaching a small sample of it. What I want to do is for all persons that are currently checked in thru a dropdown box, and forget to check out at the end of the day, a macro could be set up to run and reset all of the...
  4. Benaway

    Clear cell contents at specific time

    Have created a In and Out board for our employees. They are required to check in and out and it also has the options of vacations, remote, sick, etc. Some employees who are checked in forget to check out at the end of the day or can not for various reasons. Would like a VBA micro that for...
  5. Benaway

    VBA clear contents of cell

    Have a spreadsheet with dropdown menu for rows 1 through 10, which include the choice's of "in, out, remote, etc. The dropdown menu will be in A2. B2 & C2 are open for typing in locations, etc. What I would like to do is when the choice in the dropdown menu in A2 is either In or OUT, then cells...

Part and Inventory Search

Back
Top