Rolling Text - Looping Screens
Jul 24, 2007
1, Is it wise to have a continuous looping file like this as on some computers when this file is run it sounds like the computer is going to take off?!? (having said this it will only be ran on one computer that will never be used for anything else while the program is running)
Well - all thats happening is that the Excel workbook is hogging essential system resources - i.e. memory and CPU time and extra continuous CPU load is causing the machine to heat up which switches on the Fan.... be thankful the Fan is working
I didnt do a code walkthrough to see if there was a more efficient way of doing it, but if the machine isnt being used by anthing else, and it is in a well ventilated area (Air Con?) then I wouldnt see this as being a big problem. Just make sure the fan doesnt break down or you might have some sparks.
2, Could this be done in a powerpoint presentation. e.g have an excel spreadsheet on each slide and automatically update the links every x mins. You could then just set the slide show to continuous loop.
Well, possibly yes... the idea is good, but as far as I know you would have to rewrite the code to work in PPT. That is - you cant just drop an excel sheet with code onto a PPT slide and expect it (The Excel code) to work... you would need to code each slide again. I think... Not sure how easy that would be as I know little about PPT.
View 2 Replies
ADVERTISEMENT
Feb 23, 2009
I have four to five screens being displayed. After 10 hours the screens time out and go into password protection mode.
Is there a way to send a refresh to each of these IE windows to keep them from going into password mode.
They are being watch and security in not the problem. The hours spent logging back into four to five screens are getting really old and time consuming.
I also have MS vb express that I can use but would rather use excel.
View 9 Replies
View Related
Apr 25, 2009
In this sheet are 2 Splash screens which randomly open on startup. This is the code for them:
View 12 Replies
View Related
Jan 10, 2014
I have 3 Excel files open. There's one unnamed file that I can open in the background with no problem. Then I have 2 data files. I'd like to be able to view them both at the same time, side by side, but for some reason I cant. They both seem to occupy the same window. Every time I goto the task bar and try switching windows they occupy each other's window. Is there a way to view files side by side?
View 2 Replies
View Related
Feb 21, 2012
Have a system that runs 8 monitors on one computer. 4 are very large screens. Creates a lot of heat and uses much power.
Is there a way to dim the screens brightness in VBA. Looked all over and can't find any code.
Not really looking for a screensaver as they can cause interrup problems etc if I have programs running for hours. And I can't just turn off some screens as then desktop icons placements get scrambled.
Just want to dim screens with a macro, then undim it. Don't need to have it linked to the mouse movement, but that might be nice too.
I tried a macro that said "Dim MyScreens" but nothing happened.
View 8 Replies
View Related
Sep 18, 2009
I have an existing spreadsheet with a column of strings (actually VIN numbers). These numbers correllate to a bunch of text files, that can exist in one of three folders (UsernameDesktop1, 2, or 3) on my desktop. What I need the macro to do is:
1) get the filename from A2 (A1 is a heading row)
2) Find the appropriate text file in one of the three folders
3) Put the folder name into I2
4) Scan the text file for some strings, and copy some data that follows those strings into J2:O2 (I can handle programming this)
5) Close the text file
6) repeat above for the remainder of filenames (about 1800 files)
View 3 Replies
View Related
Feb 3, 2012
Some code below which I have inherited, basically its looping through one column of data and removing the text at the beginning before the hyphen eg. '123 - data text' to 'data text'.
HTML Code:
'Remove everything before the hyphen in the activity column
Dim SearchStr
Dim CharOffset As Variant
Range("c7").Select
[Code] ......
View 6 Replies
View Related
Sep 17, 2012
I have 2 excel files, let's call them 1.xlsx and 2.xlsx (excel 2007)
File 1 is the file where I want data copied into and file 2 is the file I want to copy data from.
File 1 has certain text strings in every say 5th column in always row 2. I want to find those strings in file 2 and if the string is found, go 6 rows down, copy the cell, and paste it into file 1, 8 rows down the text string. this is the code I came up with, but it doesn't work
Code:
Option Explicit
Sub get_data_from_2()
Dim i As Long
Dim j As Long
Dim FinalColumn As Long
Dim RngFrom As Range
[Code] .......
the bolded part gives me an error.
View 3 Replies
View Related
Mar 12, 2007
I have Excel 2002 and when I click on "Help" I would like to get the "classic" Microsoft excel Help facility, with tabs for "Search," "Index", and so on. Instead I get a screen with subject headings "What's New,"
"Microsoft Office Website," and "Getting Help". Is there a way to get the classic, old-fashioned
View 9 Replies
View Related
Jul 30, 2013
I have a spreadsheet which has data in the format of:
Date
Sales
Monday, 8 July 2013
191
Tuesday, 9 July 2013
180
[Code] ....
I calculate the average of the last four weekdays individually with =Average(A1,A8,A14..) in a cell above them to get a four week average.
Each time I add a new weeks worth of data, I manually adjust the formula to remove the first cell, and include the latest cell with new data.
I'm looking to find out if there is a way I can automate adjusting the formula so it always grabs the last four Mondays (for example)? Either in VBA or a formula.
View 3 Replies
View Related
Jun 5, 2007
I am working on a spread sheet and am trying to use rolling averages of the last 3 months. I am using worksheets for each month with a final worksheet containing the 3 mo. rolling average. I tried using a formula with OFFSET and it worked fine if all the data was in 1 worksheet, but did not work for multiple worksheets averaging to another worksheet in the same workbook.
View 12 Replies
View Related
Apr 19, 2009
Could you please supply a formula that will calculate a four week rolling average of column B in relation to the dates in column A? I tried using the average and offset functions but can't quite get it to calculate the correct averages.
View 9 Replies
View Related
Dec 30, 2009
Is there a way to make a VBA code where everytime I run this macro it adds 1 to a cell and keeps a running total?
Example:
E17 currently = 0
Running the macro makes it display 1
Running it again makes it display 2 etc...
View 2 Replies
View Related
Feb 12, 2009
I have a column of data (Column A) and I'd like to build first the Average of the first 20 data points (like in an Excel spreadsheet, cell B21 will contain the average(A2:A21), cell B22 will contain average(A3:A22), and so on... rolling).
I looked up on the internet, but I simply don't know how to start with, I mean, how to name the new array and make it rolling.
Then I will need to calculate STDEV for the same interval, and then Zscore ((Value - Average)/STDEV), but I guess it comes automatic once you made the first part.
View 9 Replies
View Related
Mar 25, 2009
I'm looking for some help to create a rolling 12 mth average. To explain better I have added a copy of the part of the sheet to help you understand what I am working with.
What I'm looking for is the 12 mth average to show up in cell c26. I have the mths listed in cell A2-A25 and the data I want averaged is in C2-C25
An additional problems is that I only want the 12 mth avg calculated if data in the next mth is greater than zero. Meaning since this month is Mar-09 (which is already collecting data) I dont want to include Mar-09 data yet. I only want to know Mar-08 to Feb-09 average. Once data is returned to Apr-09 then I want the average to show for Apr-08 to Mar-09 and so on. I dont what is better to use vba code or a formula which ever is easier.
Or if someone has a better idea please share.
PalletsTotal Orders PickedJan-083547Feb-083031Mar-083616Apr-083472May-083562Jun-083850Jul-083293Aug-082753Sep-083821Oct-083269Nov-082920Dec-083203Jan-093072Feb-093275Mar-092902Apr-090May-090Jun-090Jul-090Aug-090Sep-090Oct-090Nov-090Dec-090Average3342TL ErrorsPercentage
View 9 Replies
View Related
Aug 13, 2009
I need a formula to give me a ROLLING SUM of the last 12 entries in a column, to give a rolling year sum.
Each month a new number would be added to the column at the end just before the rolling sum calculation.
The formula then would sum the new entry plus the preceding 11 entries.
E.g. Cell values as follows: A1=10, A2=6, A3=3, A4=9, A5=4, A6=5, A7=13, A8=2, A9=7, A10=1, A11=14, A12=5
Say the sum is in cell A13, the sum=79.
A row is inserted above A13 and 7 is entered.
Now the sum calculation is in cell A14 and the calculation is from A2:A13 which equals 76.
View 9 Replies
View Related
Aug 15, 2014
I have data that is linked and is updated automatically. I am trying to use named ranges for the rolling data for each area and my date range is 5 cells using the Today()-5,4,3,2,1. The dates are rolling fine, but I cannot get the data to update, it stays the same from day to day.
look at this and see what my error is? cookies and kudos(no password on the unprotect)
View 2 Replies
View Related
Feb 5, 2014
[URL]
Alas I need to put more dynamics and fill this data set from other sheets, so I'm putting formula into column A, and this force chart react and insert another category.
In other words I want to have this fill only if data present on different tab(worksheet).
That what I have now:
[Code] ........
COUNTA
Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array.
View 2 Replies
View Related
Mar 4, 2014
how to get the 12 months rolling ppm in excel, i have tried few methods which is not accurate,
View 1 Replies
View Related
Aug 27, 2008
I have an excel sheet setup with several tabs which are organized by work days in a week. (i.e. aug 18, aug 19, aug 20, aug 21, aug22, aug 25, aug 26, aug 27, aug 28, aug 29) Sample file has been included.
I would like to do a rolling total of 1 particular cell (the same location on all the sheets, i.e. cell a2 on all sheets) for the past 4 weeks, and it automatically adjusts itself based on today's date (i.e. today is august 27, it will total everything from jul 30, 31, aug 1, 4, 5, 6, 7, 8, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 25, 26.).
Is it possible to do this?
I am not familiar with VBA or Macros, so solutions using either of these will require some detailed explanation for me to understand how to apply them.
View 9 Replies
View Related
Sep 30, 2009
One of our govt. agencies requires that I compute the 24-month rolling averages of the daily average input to a manufacturing process. In this instance, the agency is demanding the rolling average since 2003, so there are a fair number of data points involved. The process control computer can provide me the daily data (attached file contains 30 months of data), but cannot compute the 24-month rolling average.
View 4 Replies
View Related
Oct 8, 2009
I have several worksheets with thousands rows (independent variables) and hundreds columns (all dependent variables). Each line basically gives me hundreds values for each independent variable - see below:
...
C9 39.65 653.95 5.28 163.56 99.56 14.49 ... ...
E9 7535.92 21500.56 2835.88 3122.98 7225.34 5371.25 ... ...
G9 111568 298021 12940 31645 181797 36996 ... ....
...
I need to know how the values in each row are distributed, and I ideally plot a 2D column graph of the distribution. Is there a way to do that and create/program a macro (with relative button on the workboook) that does it automatically once clicked?
Very often there are outlying values (bigger or smaller by a factor of 1000 or even more), mistakes, which I would like to identify and fix possibly
View 10 Replies
View Related
Aug 18, 2009
Whenever I add new data I need two cells of the old data to not be counted. This should continue until old data isn’t being counted anymore.
EXAMPLE:
New Data entered Cell C36:E36 (148, 147, 214)
Old data shouldn’t be counted anymore from Cell C67:E68 (137, 152, 156, 94, 117, 158)
Total before New data Entered: 14066
After New data Entered: 13761
This formula is required for a total of 16 weeks or until all the old data isn't being calculated anymore in my rolling total.
I only need one total the three examples are just showing what the total should be calculated.
Sheet1ABCDEFGHIJKL3163253343433521472142103611481472141481472143732192168158192168158192168158383115417113715417113715417113739301771141681771141681771141684029114145164114145164114145164412816816615316816615316816615342272071441512071441512071441515217136160143136160143136160143531615710516815710516815710516854151031201661031201661031201665514144133153144133153144133153561313016013313016013313016013357121711531411711531411711531415811119157186119157186119157186591012111312612111312612111312660913615715213615715213615715261812118813412118813412118813462711712715411712715411712715463613913718213913718213913718264515213615115213615115213615165419313814719313814719313814766319420814719420814719420814767213715215613715215613715215668194117158941171589411715869Examples140661376113305Excel 2007
View 9 Replies
View Related
Sep 2, 2009
I need to create a Sum of numbers month to date Rolling. Meaning... if I have a expected number for the month, I need to be able to sum the processed numbers for each day up to the current day excluding any day after the current day.
So the formula would need to sumif the total month numbers UP TO the current day and compare that against the processed UP TO the current day.
Month Expected Processed
April 1 500 450
April 2 500 450
April 3 400 425
April 4 400 450
April 5 400
April 6 450
Month Total
sumif(Month range, month, processed)
View 9 Replies
View Related
Sep 22, 2009
What it is, I have a rolling report for the whole year, each with a score for the week.
However, it needs to show the whole year, but I need a seperate box with a summary of only the last 4 weeks on a rolling basis, ideally this would automatically update depending on the week.
View 9 Replies
View Related
Jan 24, 2007
See attached for example of what I am trying to achieve. I need a macro which will allow me within excel to roll down within column A a block of the same number for 25 rows, insert a blank row, and then add one to the starting number roll it down 25 rows insert a blank row and so on. I would like to start with the number 031400 and continue until 064300 the leading and trailing zeros are key so I have made column A text field.
View 3 Replies
View Related
Mar 28, 2007
My employer uses a scoring system to give a value to an individual’s sick record in the current rolling year.
Each person, has recorded, the number of sickness occasions and the total number of days in this rolling year period, these details go onto the final sheet where a score is calculated.
At present to get an accurate period, I have needed manually to deduct days to produce the correct time frame, ie 27/3/06 to 28/3/07 or when the sikness carrys on into the folling month.
I have tried without success to modify the rolling year formula, which as it is, will include the whole of March 06.
The formula is
=SUMIF(B5:D49,">="& DATE(YEAR(TODAY()),MONTH(TODAY())-12,1),L5:L49)
View 9 Replies
View Related
Jun 25, 2014
formula to input to excel to get the dates rolling down in A cell i want it to go A1(1/1/2014) A2(1/1/2014) then a3(2/1/2014) a4(2/1/2014) a5(3/1/2014) a6(3/1/2014) i have a lot of these dates to put into excel
View 5 Replies
View Related
Jul 31, 2014
I would like to set the automatic rolling month when i select month at dropdown list and this will show at C5 and need to cell at the right hand side auto change month to Jul, Aug, ... Dec, Jan, Feb.
and at left handside show the previous month.
Rolling month.xlsx
View 2 Replies
View Related
Jan 24, 2014
I am trying to create a formula that looks for the last populated cell, counts 12 cells back and returns an average for all of the cells in that range. I know I have done this before with some combination of INDEX and COUNT, but I can't seem to remember how I did it and my experimenting is not proving fruitful.
Attached is a simplified version of the layout I am working with
View 1 Replies
View Related
