cell based criteria

Hi Just copy the code from online for Pivot table filter base on Cell Reference. Its working fine f no ("blank") in filter. Its blanks its shows Error so i add this Code pf.PivotItems("(blank)").Visible = False Now i getting Run time error 13. Its Date filter base on cell Reference, Any one can...

Hi All, I am trying to have a userform show if a cell value is selected as yes from it's drop down list. any help please. Below is the code I am using in the userform code coding sheet. Code: Private Sub UserForm_activiate() If Sheets("HCR").Range("C13").Text = "Yes" Then UserForm1.Show...

Excel 2013. Have a filter created on selected cells (A1:D10), options in column B are 'ABC', 'DEF' & 'GHI". When I filter column B by 'ABC', only the rows with 'ABC' are displayed. NOW, is there a way to have a cell outside of the filtered cells, say K2, to "equal" or display the filter...

I have 2 sheets named orange book data alerts and total orange book data alerts , both sheets have data from A to M, unique value is in Column A in both the sheets. here I compare orange book data alerts with total orange book data alerts. When there is a match, compare its row cell values for...

I hope someone can help. I have an excel sheet with over 65,000 rows. I have attached a picture of what I am trying to achieve The problem I am facing is that i have a worksheet with 65,000 rows, and I have payments and reimbursements withing these rows. In the below screen shot you can see...

Hi, is there a way to change the location of cell contents to another column? In the example below I have the ">>" symbols in alternate columns in Table 1 I need all of them in column "B" like Table 2. If possible with formulas :) Thanks in advance Table 1 - actual <tbody> A B C D E Name1...

can anyone help me ... i want to insert formula in a cell base on i have 5 cells and in 6th cell i want to insert formula which tells me if min 3 cells (based on 5 cells) had value "1 " it flag true or color the cell green else red. <colgroup><col span="4"><col></colgroup><tbody> Day 1...

Hello, I'm working on a spreadsheet that has a reference table with this information: <tbody> Part Process Employee Date Time Size Serial No: Carton Weight 10366/10367 L23 MFG 06/24/14 9:58:26AM 6 435 10366/10367 L23 MFG 02/17/14 8:57:38PM 6 436 </tbody> What I need help with is...

Good morning everyoneI am new in Excel and need you help. I have search on Google, your site but could not find anything that could really help I have a drop down menu in the cell B21, depending on the value choosen, the cell B64 will nee to show a result. My drop down values on cell B21 are...

Hi, I have been trying to put the value of a cell in Excel 2010 into the status bar so I do not have to flip back and forth between sheets after changing inputs in my model. Does anyone know how to alter the code below to make it automatically update and put it into the Accounting format...

I require help in achieving the following: I have a drop down list in column A and values corresponding to Column A in B:I columns on a separate sheet. In a new sheet every time the value in Column A changes I want the values in Column B:L to also change to the new values of Column A <tbody>...

Hi, In my 'Data' tab I have various rows of data with many columns. I also have a control sheet where the user can input the criteria which they want to pull out of the data e.g. filter on column 'name' for contains 'Bob' They would choose the column name (which I then easily translate into...