I have a Table ("Table2") in a worksheet ("Dashboard") that contains monthly data arranged in rows. I have made the data fields show #NA for months I want to exclude based on dynamic criteria.
Now, I would like to automatically filter out the rows (months) with #NA so that they are not charted.
It works manually but I have to Right Click on the Table --> Filter --> Reapply every time the source data changes. How can I make this happen automatically so that the user does not have to manually reapply each time.
I have a database in Excel 2013 and now I want that when a value (a person's name) is entered in a cell. That then the database sort of filters the list for me, so it's still possible to make changes in the entries.
[URL]
Picture above to specify the search, which I would therefore like to edit
Dashboard_Action Pool Team 7.2.xlsm
I have been all morning working on a simplified version of the tutorial from YouTube: Create your own Excel Search Pt. 4. But came back later so only then that I can not change the data:?
I just got into the world of PowerPivot, Excel 2013 and Pivot Tables and am in the process of creating a Dashboard which I will then be uploading to SharePoint 2013.
On top of page I added the new timeline filter which I've linked to my pivot charts. Now what I would like to do, is create an additional pivot chart which looks at whatever date range has been used in the timeline filter and subtract 5 years from that. So, when I select a date range of November 2013 - December 2013 in timeline filter, the additional pivot chart will show the details for November 2008 - December 2013. This is where I get stuck.
I'm using two SSAS cubes which I'm combining together in PowerPivot and then display in Pivot Tables and Pivot Charts.
If I am using the "filter" function in Excel and some of the values in my list change such that the filtering criteria requires certain rows to be add/removed. Is there a way to have this filter automatically update as opposed to hitting the "reapply" button each time?
In Excel 2013, I have a pivot table showing the deals that our sales team are trying to close during this Qtr. and how much revenue we hope to get from those deals during this Qtr, next Qtr and beyond. The FILTER area of the pivot table is used to select the current Qtr.In the ROWS section, I set the "Deal ID" field with a value filter to Top 10 items by current Qtr revenue.
Data is refreshed weekly.
At the start of the Qtr, this works perfectly.
Towards the end of the Qtr, (when there are less than 10 deals with revenue this Qtr, and lots with 0), the "Top 10" filter is showing all the deals with 0.
How can I filter a pivot to show items that are >0 AND Top 10?
I am trying to save filter options to so I can apply the same filter to multiple spreadsheets. For example, I have several spreadsheets with 50 or more school names and I am trying to set a filter that will filter out the same 20 schools each time. Is there anyway to do this in excel 2013?
Is there a Column Filter Drop down Keyboard Shortcut for Excel 2013?
In Excel 2013, is there a keyboard shortcut to access the column filter drop down. For example, if you are on the cell A1, and you select Filter under the data menu and you want to filter column A without using your mouse, is there a keyboard shortcut to do this. I know Alt-A-C, clears the filters, but I want to know if there is a shortcut to access the filters in the column. In case my explanation isn't clear, I have included some screenshot pictures of the filter, before and after it is selected, to show what I am talking about, and what I am trying to accomplish without the mouse.
We have 3 PCs, all running MS Office 2013. On 1 of these machines, it is doing strange things with formatting. If you open a document or try to paste anything into certain documents, it decides everything is currency format and assigns all sorts of wrong formatting to the entire sheet, or the entire document. There may be some cells in the doc that are indeed currency, but only a small proprtion. If I open a new, fresh document and paste into that document, it does not do this, it seems to work normally, only applying currency formatting where it might be applicable. On some larger docs that have this issue, no matter what I do, it just continues to apply these strange settings.
I am using Excel 2013. I have a spreadsheet that has a lot of very tall cells. When I use the scrollbar to scroll to certain parts of the spreadsheet it will automatically scroll up or down to the top of a cell. So if I want to view the middle of two tall cells that take up the whole screen it will automatically scroll up to the top of the highest cell that I'm currently viewing.
I just want to be able to scroll to where I want to scroll without Excel moving me up or down. I've tried to find answers on message boards but no luck.
I have class monday, tuesday, wednesday & friday but no class thursday. How can I make automatically fill in dates for weekdays only and skip thursday using excel 2013's "Fill" function then "series" ??
I am trying to write a macro that auto filters a worksheet automatically any time a user activates the worksheet. I already have the macro in place to autofilter the worksheet and have it linked to a push button on the worksheet, but would much prefer the worksheet to auto filter automatically if possible.
I know how to use an Advanced Filter to sort for Unique Records Only and copy them to a new column, but I am looking for a way to do this automaticly everytime I update my worksheet.
I have a worksheet that populates an e-mail distribution list based on what you imput. Some e-mails are duplicates and I would like to eliminate them automatically before I Concatenate them into a single cell.
I imagine this could be easily done using VBA, but I am not firmiliar with writing any code so it is above my head.
My and a work college needed to combine our separate excel worksheets into a single document.
Office 2013 didn't have a function to "import sheet from file" so we used open office to import my .xlsx worksheets.
After we finished importing we exported the final workbook as .xls (so I could open it).
After opening the workbook on my pc (excel 2013) i notice some of the sheets no longer have column headers, but the row headings still exists. (No ABCD, only 1234)
Also I am unable to use features such as "Freeze Pane"
I suspect this was caused by importing and exporting through open office?
I currently have a workbook that has VBA functions that calculates values by looping through large amounts of data in a few large excel sheets. I want to transfer the data from these sheets into Access and then bring data into the VBA code via an array from the data in Access rather than the array being populated from the data in excel as it currently is. How to create the connection. The access DB will be situated in a public directory on a server. How to create the connection string and then how I call the data from Access? I have just downloaded Office 2013.
I have a complicated spreadsheet with several columns. Some columns B, D, E, F, M come from calculations on other columns or are columns copied from other worksheets within the same workbook.
I have another column C which is generated entirely off a macro with no input from the user.
I insert a row at line 8 (see above). However its just a blankrow and the formula highlighted in E2 does not show in E8 but it does appear for E9. I'd need that formula to be in E8.
My dilemma is how to insert a row and have it copy the formula from too.
I'd like to avoid copying another row into it and editing data. Other thing to avoid is putting all new rows at the end of the spreadsheet if possible. Has to be in the middle of the existing table.
I have a big spreadsheet with IT / Finance data. Below is the formula, I currently have. I am summing column Y in Tab Savings Data Detail, where column A does not equal Parent, and The Value in Column AK on the Savings data details tab matches the value in current tab for cell B26 and where column G on the savings detail tab equals Transition to IT. I am adding that value to the second sumifs statement essentially the values in column X on the savings detail tab with the same criteria.
Now I need to add to each of these formulas. I need to sum only the values where the date value in column W on the data details tab is greater than or equal to 01/01/2013 and less than or equal to 12/31/2013
find the easiest way?
=SUMIFS('savings data details'!$Y:$Y,'savings data details'!$A:$A,"Parent",'savings data details'!$AK:$AK,$B26,'savings data details'!$G:$G,"Transition to IT")+ SUMIFS('savings data details'!$X:$X,'savings data details'!$A:$A,"Parent",'savings data details'!$AK:$AK,$B26,'savings data details'!$G:$G,"Transition to IT")
I have a construction schedule that my boss wants modified. There is a pesky dot I cannot select to delete. It is on a grid line and I can only select the cells adjacent to it.
I have a workbook with several worksheets and several pivot tables. Based on the selection from a drop down box on the first tab, I want to automatically filter pivot tables on subsequent tabs. Is that possible?
I have made a small routine that updates an adv. Filter automatically, but is doesn't provide me the right outcome (seems it does nothing). I also recorded my actions and also here an empty outcome.
