leave

  1. K0st4din

    Copy selected worksheets into a new workbook and leave selected information

    Hello, everyone, I ask for your cooperation because I have difficulty with one part in making a particular macro. I've found many ways to copy multiple worksheets into a new workbook, but then I have to leave specific data in it. Explanation: I have a master workbook with 86 sheets, 28 of them...
  2. B

    Remove all Non-Printable characters as well as Clean and Trim; leave name text intact with spaces

    I saw Rick Rothstein's code that removed Non-Printable Characters, and did a Clean and trim as well. Can it be modified to leave spaces in the middle alone? such as, if I have a column of names that may have leading or trailing spaces, or both...Like so: Alfred E. Newman John Paul Jones I'd...
  3. T

    Removing all text in a cell after a certain # of characters.

    I have this formula in cell AM2: =LEFT(TRIM(CONCATENATE($G2," ",$I2," ",$H2," ",$O2," ",IF(OR($P2>0,$Q2>0,$R2>0,$S2>0,$T2>0,$U2>0)," "&$AC2&" ",""),IF($N2<>"Regular",$N2,"")," ",$K2," ",IF(AND($J2<>"Polyester",$J2<>"Cotton Blend",$J2<>"Nylon Blend",$J2<>"Nylon"),$J2,"")," ",$L2," ",$AO2)),80)...
  4. gheyman

    Worksheet Deactivate Question

    I want to run a check before the user leaves the tab. Private Sub Worksheet_Deactivate() ' Range("D1").Select ActiveCell.FormulaR1C1 = "=SUMIF(C[1],""parent"",C[9])" Range("D1").Select ' If Application.Range("D1") > 0 Then MsgBox "You or Someone has entered estimated...
  5. D

    Moving cells with formula but leaving originals behind

    I want to drag a table to another area of the worksheet but leave the original table in place. If I copy and paste the look ups will be wrong. Dragging works for the new location but obviously doesn't leave anything behind. Is this possible?
  6. S

    Issue with if/then formula

    I'm getting an error, how should I write this? =IFERROR(F4=E14,GETPIVOTDATA("Deliverable ID",$D$16), "") trying to say if f4=e14, get that info from that pivot, otherwise, leave blank..
  7. T

    Export sheets to single PDF file, but only certain sheets

    As per the title really, i'm looking to export specific sheets from a workbook to a single pdf file, the sheets are 1,3 and 4 plus any sheets found after 7 I've pretty much run myself into a brick wall with this, i simply can't see how to fix it, so i'm hoping someone here will be able to point...
  8. U

    Calculate leaves

    Casual Leave balance Calculation Period Start 01-Jun-2017 Period End 31-Jul-2018 Total Casual Leave 10 for 12 month (.83/month) but it should be calculated from date of joining. <tbody> A B C D E Employee Date of Joining Opening Leave Availed Leave Balance Leave AAA 28-July-2017...
  9. D

    IF function not working

    Hi, Not sure why i can't get this basic IF function to work. if the value in cell G3 = 0 then i want to return the word 'Expired' else leave the call blank. This is what i tried but it didn't work =IF(G3="0", "Expired", "")
  10. T

    Error Inserting Formula using VBA

    Hi all, I'm trying to get my macro to insert a formula into a cell. Basically, if the value in the column "Start Date" is found in the group US_Dates (which I've stored in AI2:AI60), then leave N9 blank. Otherwise, show "ERROR" It's throwing: Run-time error '1004': Application-defined or...
  11. E

    Value of 0 to leave the cell blank

    Just cant seem to get this to work. In cell V1 the formula is =E78 when E78 is empty it leave a 0 in V1. How do i get that to show as blank? =IFERROR(E78,"") dosent seem to work. Thanx in advance for your help.
  12. D

    VBA to up arrow and leave blank space before Paste

    Hi, In the below I need it to find "Text 1" leave 1 blank row before it pastes the contents in the selected cells. I have tried to offset but can't get it to work. Cells.Find(What:="Text 1", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows...
  13. A

    How to edit a comment box and leave box open for further editing

    Is it possible for a macro to open a comment box and leave the comment box open for further editing? I want to be able to select the cell then click a button to open the edit comment dialogue box for further editing Currently, any code I tried the box remains closed? Please advise
  14. welshgasman

    Identify multiple rows?

    Hi all, My boss wants me to try and work out a way of highlighting all rows except the first for a certain criteria. I have a column that holds a unique key, and this can be repeated for as many rows as necessary. I can easily add a COUNTIF to get the number of rows for that key, that is one...
  15. M

    Leave Earn Per Month

    Hi guys, Newbie here, I just want you to help me. Here is the situation, If I was hired last year March 6, 2017, they have given me 5days of leave (SL/VL) per year. How many days I've earned for last year that I can use this year? I just want to compute my leave earn daily by putting a formula...
  16. J

    Consolidate data set

    hi guys, I have a set of data with 1 row for each date/staff/event, is it possible to consolidate them so that it shows the start and end date if the staff number and the code are the same? if the dates break the sequence then I would like it to list as a separate row? thanks, Joe e.g...
  17. R

    Combining data validation and custom forumla

    Hi I was wondering if anyone can provide some guidance with a problem I'm having. I'm currently attempting to create a sheet to track staff leave from a table which is to be used as a default, but editable by user with a drop down. So far I'm managed to use a nested vlookup and Hlookup to...
  18. G

    how to remove #N/A?

    A B C D E G H I J K <tbody> 1 2 3 4 5 1 2 3 4 5 0 3 4 0 0 #N/A #N/A 3 4 #N/A 1 0 3 5 0 1 #N/A 3 #N/A 5 0 1 0 3 4 1 #N/A 3 4 #N/A 1 4 0 5 0 1 #N/A #N/A 4 5 </tbody>...
  19. F

    Sick leave accrual

    Hello. I need assistance building a simple spreadsheet to track sick leave that has a 1 hour for every 40 worked accrual rate. This needs to be a rolling balance set-up so if a PT employee works 25 hours one week and 30 the next, the accrual will be triggered by the 40 hour mark and start the...
  20. F

    Conditional Formatting-blank cells vs zeros

    Trying to cf a range of cells that may have numbers from 0 to 10, but some will be blank. 0=green, >0=red blank should have no formatting Red's no problem, but the 0 vs blank cells is whipping me. With just $D$5:$BC$5=0 the 0 cells turn green, but so do the blank cells. Using this formula...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top