Change Lesson Time Automatically

Feb 26, 2013

I have a speadsheet with a column of student names with corresponding columns of classes and class times. The class times are on a rotating schedule and will be35 minutes later every week. Groups A to D have rotating lessons at 8.55, 9.30,10.05, 10.40 and groups E and F have rotating lessons at 11.45 and 12.20. I need to print slips with student names and class times each week. I want to be able to update the lesson time for the next week automatically. The only way I have thought to create a custom sort list with lesson times and I drag and fill series for new lesson times. However, the list doesn't return to the beginning of the series, it creates a new lesson time. My question is, is there a better way to update the lesson times?

View 1 Replies


ADVERTISEMENT

Automatically Change Cell (With Time) Color After Time Period Has Passed

May 23, 2008

I have a protected worksheet. Users wish to be able to track changes in the input cells. The suggested approach for this is to temporarily disable sheet protection and allow them to change the font color, then protect afterwards. What I would like to do is:

i) check whether they are in an input cell
ii) if so, then prompt the user with the 'Font Color' dialog box
iii) apply the font color selected to the input cell

I'm struggling to find the dialog box I need. I can launch the one to change the interior color, no problem (Application.Dialogs(xlDialogPatterns).Show). But that's no use to me, I just want a color palette that specifically relates to the Font Color

View 4 Replies View Related

Automatically Date & Time Stamp Row On Change

Apr 10, 2008

I work in a sales team, and am currently planning the new year of sales spreadsheets (tracking prospects and orders) These spreadsheets are linked in both directions to the Sales Director's summary spreadsheet (so that she can set the targets, and also provide a summary to the MD). She has asked me whether it is possible to put a formula in that gives the date each line (1 line = 1 prospect) was updated (so that she can see whether information in the line is current / a week old / a month old etc)

Effectively, what I need is in column A a formula which references columns B-Q and if any of those change, puts in the date of change. Is this possible, or am I going to have to ask the sales guys to do it manually? I have tried to use the =Now() function, but, because the spreadsheets are linked, and auto-update on opening, every time the spreadsheet is opened, each line goes to today's date.

The previous threads that I looked at suggested either: volatile time stamp in shared workbook

or

That is bad design, Enter =NOW() to a single name cell named cell and use date =MyD-T in ALL cells needing the Date & Time. Where MyD-T is the named cell. I would advise STRONGLY against using Manual Calculation as it's NOT good spreadsheet design and a mistake waiting to happen.

View 4 Replies View Related

Display End Time Automatically Upon Entering Start Time And Time Usage

Dec 19, 2008

I have a worksheet which contains START TIME in column A, then TIME USAGE in column B and END TIME in column C. User enters start time, followed by the number of time usage in minutes, how could i possibly display the end time automatically in this scenario? how do you add the entered time usage to the start time to display the end time? Say if I enter 1:00 AM at start time and 00:15 minutes on time usage, how can 1:15 AM be displayed on the end time automatically?

View 2 Replies View Related

Distribute Names To Lesson Choice Table By Choice Priority

Dec 7, 2013

I want to make a lesson table which distribute the names to lesson choice priority.

You can see detail and explanation at attached file. LessonChoice.xlsx‎

View 3 Replies View Related

How To Change Value Automatically If Change Products From Dropdown List

Jul 11, 2014

I want to change value if i change products from drop down list.....

For more information please find attached file: Book.xlsx‎

View 8 Replies View Related

Change Value Of Combobox And Automatically Change Values Of Other Comboboxes

Aug 13, 2012

I'm coding a userform where there are some comboxes which are popolated by values coming from Sheet2. Up to now I work it out (maybe its not elegant but it works).

Now I would like that when the user selects one combobox the values of the other comboboxes are set accordingly to the grid in Sheet2.

Please download the XLS file at: [URL]....

View 2 Replies View Related

Excel 2010 :: Insert Date And Time In Column Upon Data Change For First Time Only

May 3, 2013

I am looking for a macros VBA where a user insert or update a data the date and time should be insert in column I and save the workbook.

Note: If the column I already have the date and time inserted before then it should give message record already have date and time.

I am using office 2010.

View 9 Replies View Related

Weekday Formula: When I Change The Month, It Automatically Will Change My Formula

May 9, 2006

=CHOOSE(WEEKDAY("1 Jan " &$C$1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

where C1 = the year 2006. B1 has the month Jan and I want to input that into my formula, so when I change the month, it automatically will change my formula. I tried =CHOOSE(WEEKDAY("1 $B$1 " &$C$1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

B1 = Jan
C1 = 2006

View 7 Replies View Related

Change Tracking Automatically

Aug 21, 2007

I have a spreadsheet i would like to have changes tracked to automatically. I know it's only a matter of clicking a few buttons to get this to happen, but i was wondering if there is a way to have excel do this by default when i open the file. I would also like to have the changes highlighted automatically.

View 9 Replies View Related

Change The Code To Automatically

Feb 23, 2007

Is there a way that I can add a statement or change my code to automatically have the checkbox checked if a certain value in a cell is greater than zero?

This is my
If CheckBox1.Value = True Then Range("RANGE_WATER_AND_SEWER").PrintOut Copies:=1

If CheckBox2.Value = True Then Range("RANGE_ELECTRICAL_SERVICE").PrintOut Copies:=1

etc. Note: I have about 80 checkboxes on my form.

View 9 Replies View Related

Change Automatically When I Put In Certain Values

Oct 2, 2008

I want the value in cell D12 to change automatically when I put in certain values. If I type in "Weather" I want the cell to change to say "WOW". If I type in "Bell Run" I want it to change to say "BR".

View 9 Replies View Related

Add Zero Automatically In A Time Format.

Dec 22, 2008

I have been battling with this report I have been working with for sometime. Is there a way in Excel where I can automatically add zero into the time format?

The problem is I have to import data from another source and the time displays as a time format showing :59:00 insted of 0:59:00. Excel will not sum the calculation without the zero infront of the colon. This makes my report very time consuming. Can someone show me a way that I can automatcially add zero's infront when having data under 1:00:00?

View 6 Replies View Related

Automatically Run Macro At A Particular Time.

Aug 26, 2009

I would like to run Macro_1 at every day 3.40pm. I have inserted following code to workbook.

Private Sub Workbook_Open()
Dim when As Variant
Dim name As String
Dim torlance As Variant
Application.OnTime when = "15:40:00", name = ("WeeklyStockReconciliation1")
End Sub

View 5 Replies View Related

Automatically Updating Time + VBA

Nov 20, 2009

Based on the attached I want to make the time automatically count down in MS Excel using VBA.

The attached will give you a flavour for what I want to achieve.

View 3 Replies View Related

Automatically Save At Certain Time

Jan 3, 2007

I would like to save a spreadsheet at a certain time every day.

View 5 Replies View Related

Update Time Automatically

Apr 25, 2007

I have a cell (H2) that contains the formula =NOW(). I would like this cell's time to be updated every minute automatically, with a Macro that will start itself the moment the spreadsheet is opened. I have attempted to find other users with the same question and have attempted to use Macro's supplied however without success. I have previously found this piece of ...

View 5 Replies View Related

Change Graphs Automatically When Row Inserted

May 25, 2014

I want the 2 graphs in "Graph" worksheet to change automatically when a row is inserted in "Data" worksheet . Every time i have to change the graph manually to contain the latest 20 days value. I want some offset or something which can be put in the range provided below to do the work.

Chart Data Range =Data!$A$1:$A$22,Data!$F$1:$F$2,Data!$L$1:$L$20

Legend entries (Series) - Series Name =Data!$F$1 ( this will remain constant everyday as this is a header field)

Series Values =Data!$F$2:$F$22 ( this should contain last 20 days range, for example if a next row is inserted tomorrow then it should automatically change to =Data!$F$3:$F$23)

Legend entries (Series) - Series Name =Data!$L$1 ( this will remain constant everyday as this is a header field)

Series Values =Data!$L$2:$L$22 ( this should contain last 20 days range, for example if a next row is inserted tomorrow then it should automatically change to =Data!$L$3:$L$23)

Horizontal (Category) axis series -Axis Label Range =Data!$A$2:$A$22 ( this should contain last 20 days range, for example if a next row is inserted tomorrow then it should automatically change to =Data!$A$3:$A$23)

Sheet attached : Devicess.xlsx

View 6 Replies View Related

How To Automatically Change The Link To A New File

Dec 21, 2012

Basically, at month end, my company will create a new folder with the name as YYYY_MM (e.g. 2012_11). In this folder, a new file will be created as: earnings_YYYY_MM (e.g. earnings_2012_11).

What I want is to automatically update the link to the most recent file: earnings_YYYY_MM, whenever it is available. For example, next month there will be a new file earnings_2012_12 created in the new folder 2012_12, then the new file will be linked with.

View 1 Replies View Related

Automatically Sort Due Dates As They Change?

Aug 15, 2014

I'm attempting to get a column of due dates to update automatically every time a date changes. The due dates are in B3:B15. There is a header in B3. The day after the actual due date, it is automatically changed to the same day on the next month (showing the next due date). I need the spread sheet to automatically sort the due dates from the closest due at the top, to the furthest due date from today at the bottom. Running it manually, or sorting it manually every time won't work. This is for an elderly couple who are having problems keeping track of everything each month. I just need something that will show them the upcoming bills and how soon they are due when they open the workbook. Anything other than opening the workbook is going to be too complicated. I'm new to macros. I've tried to modify some I've found in other threads, but no luck (lots of error messages). I don't understand it enough yet to figure out what I need to change. I've attached a sample sheet that shows the part of the workbook I'm having trouble with.

View 4 Replies View Related

Change Automatically Without Double-clicking?

Apr 14, 2014

A
B
C
D
E
F
G

I have a spreadsheet with formulas in column C, D, E, F and G. The only numbers I need to enter are in columns A and B. The formula in column C comes from the =SUM(B1/A1) Column D is calculated based on the result of column C, etc...

How can I set up the spreadsheet so that when I enter the data in column A and B, everything else calculates automatically; without having to double click and press enter in each cell?

My Goal: To put data (numbers) in Column A and B and than have C, D, E, F and G calculate by themselves without clicking.

All of my cells contain numbers, not text

View 6 Replies View Related

Automatically Change To The Cell The Hyperlink

Jun 9, 2008

Is there a way that under "Type the Cell Reference" that you can make it automatically change to the cell the hyperlink is on?

The reason why i ask this is because I have hyperlinks linking to there current cell but once i delete a row above that... the cell refernece doesnt change therefore changing the cell reference to the cell above it

View 9 Replies View Related

Automatically Macro Run When Date Change

Feb 22, 2009

Is it possible to have a macro run when a date is changed each month instead of clicking on the button. I have a few macros that are ran each month in a spreadsheet (manually) but would I would like to have them run automatically when the date is changed in cell a4 each month. The date in cell a4 is always the last day of the month. Also the name of the workbook changes each month

View 9 Replies View Related

Automatically Re-apply AutoFilter When Any Change

Jul 17, 2009

I'm working on an excel sheet to display technical problems in an office. I want to use a filter in order to not display problems that were resolved (by applying a filter to show only "0" on the "problem duration" column that displays "hours problem was up after solved" and "0" if not solved) as the point is to display only non-resolved issues.
I wanted this filter to be re-applied constantly, meaning once I fill the time and date it's solved and the formula calculates the time it was up, this row will automatically vanish due to the filter applied.

I found this thread on your site Refresh Autofilter Automatically from the resolved problems so we need to remove the filters once in awhile. With this after the filter is removed, you cannot setup a new filter at all (it just doesn't seem to allow you, erasing it after it is being applied). I need to not only be able to setup a new filter, but also that this new filter will be reapplied automatically all the time (temporary disable of a filter is also an option, but I do not know whether it's possible).

I do have Excel 2007 on Vista, but I also need this to work on Excel 2003 with XP.

View 9 Replies View Related

Automatically Change Currency Format

Jul 13, 2006

AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy/pasting, but IS if the keyword uses "quotes".

USD 100
EURO 100

Is it possible to automatically make it:


USD $100
EURO €100

View 9 Replies View Related

Chart Scales To Change Automatically

Jan 20, 2007

I have 3 charts on 3 seperate worksheets. The data for each is sourced from a list of up to 100 but only the top 20, or all if less than 20 in full list, are displayed on the chart. A seperate worksheet ("Calcs") is used to sort all the data so that just the top 20 are sourced for the charts and they are displayed in descending order from max to min and alphabetically in the case of 2 or more names having the same value.

I have attached one ot the charts.

I need the y axis scale to auto-adjust to suit the max and min series 1 values. I need the y axis maximum to be 5 more than the max series 1 value (unless the value is 5 or less when axis should be 10) and the min y axis to be 3 less than the min series 1 value (unless the value is 3 or less when the axis should be 0)

I have done the formulae to sort out these conditions and put the required y axis values in a cell which the copies across to the chart sheet with the required max in cell M1 and the min in cell L1. These values will change when another macro runs.

I searched this site for the code to auto-adjust the scales and found one which I have tried to edit to suit my needs. This is the code I have ended up with, placed within the worksheet containing the chart....

View 9 Replies View Related

Automatically Autofilter Upon Data Change

May 4, 2007

I have a worksheet set up with code to have it Autofilter. My criteria is that if it has 0's in column d then it gets hidden.

This sheet is automatically filled in from information on another sheet.

Is there anyway that when the information is changed that the AutoFilter will automatically refresh itself?

View 4 Replies View Related

Cells Automatically Change Color

Sep 25, 2007

I have been given a spreadsheet that turns whole rows different colours when certain data is entered into a cell. I want to locate the code and use it elsewhere, but cant find it?

I have looked at all of the change related procedures in the drop downs, for the Workbook e.g.

Workbook_SheetChange

but no matter where I cant seem to find any code at all.

Is there a way of exporting every line of code and then open this file in notepad to skim through it?

how I might find the code that is making the rows turn different colours?

View 3 Replies View Related

Automatically Change Print Range

Jan 5, 2008

I have an Excel file that I believe was a template, maybe from MS. It's a loan calculator. Anyway, whenever you change the interest rate or number of payments it somehow knows to only print those rows - even though there are formulas in many of the rows beneath the print range.

View 4 Replies View Related

Update Time Automatically In A Given Cell

Mar 1, 2008

Is is possible to have Excel update time automatically in a given cell within the spreadheet.

I have a spreadsheet that I need Excel to update the time automatically .

I would like Excel to update the time automatically in cell A1.

I have done some research and found the following thread but this only works when we close and open the spreadsheet.....

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved