I would like a program where I can enter appointments at certain dates and times and then a pop-up message will appear to alert me for the individual ones. Similar to the calendar function in Outlook... but, do not use Outlook as my main email, therefore I won't get alerted. Has anyone created a program in Excel that can solve this?
Also, is there a way to keep the program running in the background (even when nothing is open)... so that I don't miss appointments?
thx!
I am an excel veteran but am not sure how to accomplish this task.
I have a day planner that I wrote with Office 2000 back in the day that has followed me around since then. I just decided to rewrite it from the ground up using Excel 2007. In my old version I had it setup so that one day would print on one side and the next day would print on the other side, but each day had its own columns and rows dedicated to it. The spreadsheet was long enough to print out a quarter at a time (Jan-Mar, for example). The first day of each quarter I would enter in the date (10/1/2008) and a formula in each day would then update that day's header to show the correct date.
This makes for a huge spreadsheet that runs real slow.
Is there a way operate excel like a mail merge? Can I have just one page and when I print say, 90 pages, the date changes at the top automatically as it prints?
Any ideas?
Thanks in advance,
Keith
Hello
I would apreciate all help possible on the following:
I have a sheet with a booking list like this:
cOLUMN 1 COLUMN 2 COLUMN 3
APRT ARRIVAL DEPARTURE
c1a 01/01/2010 05/01/2010
c1a 09/01/2010 12/01/2010
And I what for these dates to fill/display automatically as follows in a separate sheet;
A B C D E F G H I J k L M
01/01 02/01 03/01 04/01 05/01 06/01 07/01 08/01 09/01 10/01 11/01 12/01 13/01
C1A X X X X X X X
All help is much apreciated
I'm trying to make a lesson planner with text and numbers. I want the text to stay the same in each cell but have the numbers increase by 1 each time. I cannot figure out the formula.
Example:
Cell 1: R&S 1; Cell 2: R&S 2; Cell 3: R&S 3
Thanks, Kelly
i am trying to build a holiday planner, i am a beginner @ excel and i think i took on too much, but anyhow,
i am trying to get a few things happenning
1, have a main sheet to input holidays date from, date too which is easy enough but on sheet 2 i would like to take the info from sheet 1 and put it into a month with a max amount of persons of 10 having holidays at any one time else it would read space Free.
2 from a main sheet of rotas i have have got i would like to have total hours in week worked but this would be easy if it was day shifts but its nightshifts i.e 22:00 - 06:00 =(8) 7 hours with a hour taken off for dinner then with that information i would like to get holidays left to take in hours and days taken from the main holiday hours on main sheet all holidays input manully,
and a few other things
if anyone can help me with stting this up or some software/freeware already avaliable please contact me
Does anyone have a good work/staff year planner.
I have requests from others that I need to assign to my staff on specific dates/times over the coming year.
Anything would be appreciated.
Hi all,
I'm trying to make a creative and easy to use holiday planner that'll be used with the heads of departments in my office.
I so far have the general layout of how I want the worksheet to look (see images below). The calendar covers the entire year (horizontally).
and the userform for the worksheet
What I'd like to do is have a user open the userform from a button on the worksheet (not yet added), select an employee, the type of absence (holiday, sick leave or other) and add the "from" and "to" dates. When they hit submit, the userform will match the employees name from the drop down to the worksheet, note the absence type selected (which should format the target cell(s) accordingly -holiday is green, sick leave red and other blue) then find the "from date" and the "to" date and format (colour) the cells horizontally between these two dates.
I have been plugging away at this over the last day trying different types of code examples people have used for similar workbooks, but haven't the experience or skill to adjust them properly. I'm currently stuck on two things; displaying the dates correctly in the two date drop downs, and of course the submit functionality that adds to the sheet.
For the dates drop downs, i was trying the RowSource property and simply copying jan 1st to dec 31st ($C$3:$NC$3) but it doesn't display the dates correctly.. just numbers.
For the Submit button, i'm completely stumped.
If anyone can help me with either of these two problems, I'd be very grateful!
Thanks in advance.
Adam
Hi
Can anyone help with a formula for the following:
Column A contains a list of tasks (one task per row) - columns D through Z are headed 1 to 23 (wk numbers).
Every task has a duration represented by an amount of hours entered into the corresponding week columns. It's essentially a simple planner.
In column C I want to return the column number that relates to the 'earliest' or first entry for the task; which week (column number) does work start.
In column D I want to return the column number that relates to the 'latest' or last entry for the task; which week (column number) does work stop.
I hope this is clear enough to understand. Any help appreciated.
Thanks.
i have a spreadsheet that has dates in column A and names in row 1
is there a way i can use vba to update a cell by matching the date and name together ( think Battleships)
Textbox1 = name
textbox2=date
textbox3= "1.0"
so i want the cell that falls in the grid of name X (axis) and date Y Axis)
i can do this as a formula but as each cell needs a formula in it, it take ages to process the information.
Hi All,
I am still struggling with a problem to convert lets say 6.33 days into days/hours/mins on a holiday planner based on a 7.5 hour day.
Any solutions?
