I've written a Fantasy Football programme, which is 100% working, however I would like to have the highscoe table update automatically, rather than using the data/sort command. E-mail me and I'll sent it to you with what I'm trying to do.
View 2 RepliesI want to create a table that updates automatically with the name & highest score top.
I.E. currently I have :-
Dates starting in A4,
names B2 : K2,
scores B4 : K4,
Not too fussed about having the date in the results table but i'd like something like :-
Scott 4 points,
Geoff 7 points
Tony 2 points,
I would like a table to automatically sort a table (preferably on sheet 2) so it looks like :-
Geoff 7
Scott 4
Tony 2
Is this possible ?, I only have 6 rows of data so far so it can be re-arranged if needs be and data will be added each week.
how can i make a worksheet/formula that automatically look for the equivalent score in a given transmutation table.
example: i have an exam of 10 items, what will be my formula to so that it will automatically look for the equivalent score under the transmutation table of 10 items
I have existing Pivot Tables that have a data source on another sheet that varies in size.
How can I have the pivot tables' data ranges reset to match the number of columns and rows on the data sheet?
I have two worksheets in my workbook;
1. Table
2. Raw / Source data.
I have entered all the formulas into my table (sheet 1) referenced to the source data but I want to upadate the source data regularly but when I delete sheet 2 all the formulas come up with #Ref error. how i can update my source data so my table automatically updates
I have 2 pivot tables in a worksheet.
The names are "PivotTable1" and "Pivot Table2"
Cell H2 is the worksheet has a currency type, ex) EUR, CAD, GBP
Column 1 in each pivot table is "Currency Pair Sell/Buy"
Based on Cell H2, I want the pivot table filters in column 1 to show 'USD.currency' and 'currency.USD'
For example, if H2 = EUR, the pivot tables filters in column 1 should only show USD.EUR and EUR.USD.
Any template for this type of code, I can fill in the blanks with the relevant sheet names and other information that might be needed.
I have an interesting problem (I hope you find it interesting too). I'm trying to find the historical "high" day of the week for a particular stock I follow. I searched for several hours but was honestly unable to make any progress. Normally I do my own formulas, so other than pasting a rare macro, that's pretty much the extent of my (lack of) experience, ie please assume I am a novice....
View 9 Replies View RelatedLet's say that in column A I have numbers,"Yes" and "No". I want in column B to have only the numbers from column A, in the same order without any empty ranges, and everytime I add in column A a new number, column B to update automatically with that number. Let's have an example:
A B
Yes 12
12 13
No 10
13
No
10
Yes
And if I want to add in column A:
A B
Yes 12
12 13
No 10
13 25
No 15
10
Yes
25
15
So the column be will update automatically. I already tried =IFERROR(INDEX($A$1:$A$10,SMALL(IF(ISNUMBER($A$1:$A$10),ROW($A$1:$A$10)),ROWS(B$1:B1))-ROW($A$1)+1),") but using this many times get's my file very heavy and the excel is working slow.
I'm trying to find a way to return a value (score) based on the results in a table. I've been trying to use index and matches but am starting to think this will not be the answer for this one.
In the example attached, I have a section called report. For each project, there are criterias which need to be scored based on the values in the lookup table.
For example, project 1 has a result of 200 for criteria 1. On the lookup table 200 in criteria 1 would receive a score of 2. This result is then populated in column L as the score of this criteria.
So, I have a table of scores from players for a category I have. It looks like this:
Place-------------Name-------------Country-------------Score
1st---------------Jim----------------USA--------------------376
2nd--------------Michael-----------Germany-------------364
2nd--------------Tim---------------USA-----------------364
4th---------------John--------------Norway-------------355
if one of the guys, for example, John were to improve his score to a 369, I'd change the score in Excel, then use the sort feature to put him above Michael and Tim. Only problem is, it would say his place is still 4th place, and it doesn't change to 2nd place.
I want it so the "Place" column automatically changes to the correct rank based on the score the person has. So if I changed John's 355 score to 369 and hit sort by A-Z, Excel would automatically change the "Place" he's in appropriately so it would look like this:
Place-------------Name-------------Country-------------Score
1st---------------Jim----------------USA--------------------376
2nd--------------John--------------Norway--------------369
3rd---------------Michael-----------Germany-------------364
3rd--------------Tim----------------USA-----------------364
i have three sheets in this workbook. i want to filter the the pupils with less than 20 marks in total at the end and copy it to the page named filter, from which i will go to the sheet1 which gives a remedial plan for ONLY those pupils who come in the filter page. this is all good but the problem is that when i update the Cont page, it wont update in the filter page.
View 6 Replies View RelatedI want to see if i can make a formula that works out how a player got a score based on a scoring system. See the attached file for more details. I want this to show that the player scored or didn't score, played a full match or was a substitute, was booked or wasn't booked and was sent off or wasn't sent off.
View 5 Replies View RelatedI have a basic formula =C17+'Asset Depreciation 2008 Onwards'!C24, and I want to copy it down just using the drag function. Problem is that the second reference range of cells are in rows and hence when I copy it down it doesn’t automatically update the cell references because it want to update them by column number instead of row number. IE I want it to display =C17+'Asset Depreciation 2008 Onwards'!
D24, instead of C25. Do you know if there is any way of telling Excel that I want it to increase the column number by 1 every time, instead of the row number for this part of the formula?
I have created a table in Excel 2010 (pls see attached table named post.xlsx).
Then copied the above table into PowerPoint 2010, using "paste link" (I tried to attach the PowerPoint file but the system says "invalid file type" and I cannot attach it).
Question:
I have received income data for another month - the new month is 13 and the corresponding new income is 100.
I typed 13 and 100 into the Excel table post.xlsx and thus extended the table by another column.
Then I went back to PowerPoint slide, then right clicked on the table there, then clicked "update link".
Specific Question:
The newly-typed column in Excel table is not get updated in PowerPoint table.
We have a worksheet that contains twelve different charts. Once a month, we load data into anotheer worksheet and run a macro and it produces the twelve charts. The problem is that we have to manually update/change the month name in each chart title every time we run the macro to produce the charts. Is there a way to automatically update the month name so that we do not have to manually do it? For example, the current chart title is "xxxxxx - March 2014"....when we run the charts for April, we have to manually change March to April in each of the charts. Can this be done automatically?
View 2 Replies View RelatedThis what my excel sheet looks like that i am using the date ant time cell is set by using the now formula to get the current date and time, but I only want the date tiem change for each row when it changes.
For example when the data for the first row changes all the dates and time change, but I only want the effected rows time to change not all the times and dates, this progam is set up to monitor inventory and when some makes a change to the inventory I need to now when the that data was recorded but do not want the users to have to enter the data and want it to be enter automatically that is why i am using the now function. The data may not change at all for a couple days that why I need to be able to keep the Date data from changing automatically.
Bin #ProductAmount
D-21Red Lentils 3/47/7/09 1:54 PM
D-22Red Lentils 1/27/7/09 1:54 PM
D-23Yellow Peas 3/47/7/09 1:54 PM
D-24Yellow Peas 3/47/7/09 1:54 PM
D-25Yellow Peas 3/47/7/09 1:54 PM
D-26Yellow Peas 3/47/7/09 1:54 PM
D-27Yellow Peas 3/47/7/09 1:54 PM
D-28Yellow Peas 3/47/7/09 1:54 PM
D-29Yellow Peas 3/47/7/09 1:54 PM
D-30Yellow Peas 3/47/7/09 1:54 PM
I have a worksheet with a cell that references another cell.
Cell A1 references cell B1, and the value of cell A1 is "=B1"
When I type anything in B1, A1 won't automatically update to reflect what I've typed. The only way I can get it to update on the fly is to save the workbook. Even when I close the workbook and reopen it, it still won't update to what I've typed in B1. Is there a setting that keeps it from autoupdating?
I require a total amount of 'cost price' items we have in stock.
As you can see from sheet 1, 'Adidas', the total is £43.00. However that is not the cost of stock, as some items are not in stock, as per Column I. (The cost is actually £36.00).
How can I make a total to include just items in stock? Bear in mind new stock is inserted between others in order of Model so the forumale would need to update automatically, and there are several hundred sheets, not just 2.
I have a dashboard (CW Dashboard.xlsx) that is linked to 3 main spreadsheets. In each main spreadsheet, there are 5 tabs. One tab contains raw data, the other 4 tabs contain tables: 2 tabs with formulas based on the raw data tab, and 2 tabs linked to 20 other spreadsheets (for now). I separated the raw data into 3 spreadsheets because Excel was calculating way slower than my patience would tolerate. All spreadsheets are Excel 2010. All spreadsheets reside on our network drive.
The links update as expected on the 2 tabs that are linked to the 20 different spreadsheets in each of the three main spreadsheets.The CW Dashboard does not update. I get #REF! in each cell (although when I click in the cell, the link shows no error). I am using VLOOKUP and HLOOKUP in this spreadsheet. I can of course open the source documents from within the Dashboard and the links then work as expected. However, I would prefer the eventual users of the Dashboard not have to open 4 s'sheets.
I have attached a sample of our worksheet (GTS807) used to create quotes and generate jobsheets etc once they are orders. To ensure we have enough of a size in stock I want to carry out a check against the stocksheet (stock) which I have no problem but I cant get it to automatically update the stock once a quote becomes an order and removes the quantity from stock!
As you see the balance of stock in shown in AA13 for "115270" but is there a code to find "115270" on the stock sheet and copy the new balance back there?
I have an excel based appliction that I distribute to about 150 people in the US, London, Hong Kong and Singapore. Distribution is currently done by email containing a link to a Sharepoint site (the email has the link, release notes, etc). The end users open the file and save it to their desktops, overwritting the previous version. I'm finding that many users are not updating their versions as they should be.
So what I'm wondering is if there's a way to have this process automated - so that when the user opens the file, it checks a repository (sharepoint or otherwise) for a more current version, then prompts the user to download it.
In my worksheet I have a data validation dropdown which changes the value in a cell. I then use VLOOKUP to find values in Personal.xls (open) based upon that cell. It works great, BUT if I make any changes to the data in Personal.xls it doesn't get updated in the other file. I've tried saviing, closing, opening etc but it never updates since I first did it.
View 7 Replies View RelatedI have a working VLOOKUP formula for generating a one page inventory list. It grabs values from worksheets in other spreadsheets. The only problem is it doesn't automatically update.
View 6 Replies View RelatedIs there a way to automatically update football stats from a website. I want to update many different stats each week of player and team performances. Can I specify a website to go to update the info and prefer to do it each Tuesday. Let me know if more details are needed.
View 1 Replies View RelatedI have three columns as below,
Column A current Amount
Column B Increse %
Column C Revise Amount
If I put revise amount in column c, than Column B update automatically or if I put % in column B than column C update automatically, update must be live
I am trying to create a simple scoring system for sports that use a "legs" and "sets" format (e.g. tennis, darts etc.)
I would like the "sets" cell to automatically update as the "legs" cell reaches the required amount of legs to win a set. After that I would like the "sets" cell to continue to count upwards when/if another set is won. Is this possible?
I have a form that laods when the workbook is opened. I also have an MS query that retrieves data from another source. When i open the workbook without the form loading i get a message asking if i want to update the query automatically. When i open the workbook with the form opening the message doesnt show until i close the form meaning i have no data in the sheet to use. Is there a way to get the query to refresh before the form opens?
View 2 Replies View RelatedI 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 RelatedI'm trying to update an excel document which has a list of employees on it along with their training. Most of the training for individuals needs refreshed in the next year so wanted the table to use the date and perhaps trigger a fill colour change once they are close to needing that training. here's an example
John Smith
course 1
Completed 01/05/10
Refresher required 01/05/14
Once we get a month or two before the required date, I would like the fill colour to change to highlight that they refresher training should be organised soon.
Lets say I have two sheets titled "dashboard" and "raw data" in a workbook. Cell A1 in "dashboard" should always show the most up to date data from Row 1 in "Raw Data".
I update "raw data" daily, adding a new column to Row 1. For example December 19 would be A1, December 20 would be B1, December 21 would be C1 etc...How can cell A1 in "Dashboard" always reference the newest cell in Row 1 of "raw data"?