leave

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...

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...

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)...

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...

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?

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..

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...

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...

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", "")

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...

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.

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...

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

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...

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...

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...

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...

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>...

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...

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...