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.
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...
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...
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...
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...
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.