1. M

    row protection based on specific cell

    Como protejo automaticamente uma linha com base em uma célula? Exemplo: se você inserir um valor na célula E1, ele protegerá automaticamente as células à esquerda da linha, D1, C1, B1 e A1 E o mesmo se aplicaria às linhas seguintes, se você inserir um valor na célula E2 ele protegerá...
  2. Jyggalag

    Color the area inbetween two lines in a chart/graph?

    Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...
  3. B

    manipulating plotted lines on a graph

    I have plotted lines for three data sets and am required to manipulate the data in a couple of ways in order to make each line start at (0,0). I have attached an image of my raw graph for reference below. Essentially I need to extend the linear portion of the line to the x-axis as shown below...
  4. T

    Backlog in DataBase.

    Hi guys, I need to create a short schedule about my backlog in my DB. As you can see I have 5 category ( PWHT ,MPI/PT, HT, RT, UT ) with a little backlog ( PWHT 4 , MPI/PT 0 , HT 7 , RT 16, UT 0 .) and I want to see only Backlog Lines from my DB. DB range in Sheet1 A2:CC367 and also after...
  5. Jyggalag

    Making a frontpage in Power BI?

    Dear all, I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :) I currently have the following Dashboard: Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...
  6. J

    please help me

    I have some text and digit in A1 to J1, but i want that if i type "O.K." in K1 then all line A1 to J1 changed to Blue Color.
  7. D

    Generating email using VBA

    Hi all it's me again, I'm using some code from Ron De Bruin's site to generate an email using the following code Sub Mail_small_Text_Outlook()'For Tips see: 'Working in Office 2000-2016 Dim OutApp As Object Dim OutMail As Object...
  8. N

    Deleting Columns Faster

    Hello all- I am running a line of code to delete multiple columns of unneeded info, this is what i am running: Range("A:B,H:H,J:AD,AG:AK,AN:AX,AZ:BJ,BL:BN").EntireColumn.Delete Is there a way to run this code and make it go faster? I have a timer on for this line and its taking between 9...
  9. T

    Pivot Table

    I have a column that I want to filter on in a pivot table. The column contains multiple values in some cells, how do I filter out only words that contain certain cell ranges: For example these are all values in the cells and I only want to see the rows that contain HART for example? Thank you...
  10. masud8956

    Problem refreshing charts in multiple sheets depended on data from specific sheets

    Hi, I have some data involving dates {including =TODAY()} and numbers in Sheet1 and 2. Sheet 2 is hidden from view. in Sheets 3, 4 and 5, I have several charts (Line, Doughnut and bar chart). The line chart is located at Sheet3 getting data from Sheet2 only (hidden sheet). Doughnut chart is...
  11. M

    Best way eliminate rows with multiple status from a count?

    I receive data from our ERP system on vouchers that create errors. I want to have a measure that tells me how many voucher lines were closed within the last week. But... a voucher can create multiple errors - one might be closed during that week, but if the same line has an open error I don't...
  12. D

    How to include double quotation marks in a formula in vba

    I am trying to insert a formula using vba but it gives me a syntax error, what is wrong with this line of code? .range("C11").formula = "=IF(A11="","",IF(COUNTIF(Sheet2!$G$87:$DO$97,A11),"Public Holiday",IF(WEEKDAY(A11)=1,"Sun",IF(WEEKDAY(A11)=7,"Sat","Mon-Fri"))))"
  13. P

    Excel 2010 formula to look up duplicates so I can contra them off

    Hi, first of all thank you for looking at this post. I have started a new job and am wanting to improve the speedof the month end process. I have to download the information from Excel from thenominal ledger to review (approx. 3000 lines) some of the values are the same butare pluses and...
  14. W

    Prevent a dynamic line chart from interpreting formula output of "" as 0?

    I have a formula in a table that uses an IF function. The output of the formula dynamically plots a line chart. The problem I'm experiencing is that if the output of the IF function is False, then the "" value output is interpreted by the dynamic line chart as a zero instead of a blank cell...
  15. S

    Compare each cell of a row with another row from another excel file

    So, hey people. Thank you for reading this and for putting some thought into it. I have a long line in an excel file, let's call it X, that I need to compare it with another line from another excel file, we'll call it Y. The thing is that the Y line has the same first 6 cells as the X one...
  16. A

    Insert a line break after word wrap

    I have a multi-line textbox I want to insert a line break after word-wraps to a new line. Can someone help with a vba code that can do this. Thank you kindly
  17. J

    Userform, textbox copy to sheet

    Private Sub ToggleButton2_Click() Me.TextBox1.Copy Sheets("Data Sheet").Range("L" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues Struggling to achieve a simple copy to the next available row in column L from a textbox in a userform. It is failing on line 2. Any...
  18. N

    No data labels on Pareto Line of Pareto Chart

    Excel in office 365 now has a dedicated Pareto chart which is quick and easy to use. However, there is no option to add data labels to the Pareto line to show the percentage values. Am I missing something obvious here?
  19. F

    VBA to Send or Display Email

    I have a code that sends an email with pdf attachment. I have a dropdown in cell L3 with options Display and Send. Depending on what is chosen I want to either Display or Send the email. I can't seem to get the code to work. Any help would be appreciated. Below is the email section of my code...
  20. R

    Send email on workbook refresh

    Hi I think this is a big ask, but here goes! I have an excel sheet which is refreshing and pulling data from a googlesheet. What I am wanting to do is when a refresh occurs any new line will trigger an email. The data coming in will include an email address (Column J) I would also like to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back