joe4

Hello all, I'm having trouble with conditional formatting formulas for the following percent complete versus start and end date situations. I've also included a screenshot to give you a better picture. -On Track (Trigger- Based on the current date, the task will be completed on time by the due...

I have a formula that automatically calculates the percentage of completion on a project between two dates (the start date and end date). The formula I chose to use is: =IFERROR(MIN((DATEDIF(D11,TODAY(),"d")+1)/(DATEDIF(D11,E11,"d")+1),100%),0). However, when column D and E are not populated...

Hello, I have formula that automatically calculates the percentage of completion on a project between two dates (the start date and end date). The formula I chose to use is: =MIN((DATEDIF(start date column, TODAY(),"d")+1)/(DATEDIF(start date column, end date column, "d")+1),100%). However...

HI EVERYONE.... I want to Export an Access Database table on OneDrive Folder Online Into an Excel format file. So i want to protect the file's data with Password protection. I exported a table with help a Macro command as i want but it Visible and Available to everyone. . . . . Is there any...

Hi Everyone, Happy New year to all Great ones. Please help in achieving my task, I have tried to some macros and some vba code to do some work in this workbook, actually I have prepared this excel for stock and inventory management as per our requirement. In this workbook user can do following...

Can someone please help!!! I am needing to find a code or rewrite mine so that when I press the assigned macro button it will generate a new row below the one that is above it. This is the code that I have. Sub NEWSUBMITTALCOVER() ' ' NEWSUBMITTALCOVER Macro ' *Create a new submittal ' '...

Hi All, I have multiple excel workbook ( 85) in one folder. Each workbook contain 13 sheets has same names with different order. Only Excel workbook name is different. Now I want to assign all workbook sheets in one order. Kindly note Its not assent or dissenting order. I had listed all...

Hi Guys, I am trying to run a piece of code in all the sheets in a workbook. However my code is only editing first sheet and then courses through other sheets but does not edit them. PFB the code: Sub Worksheet_Editor() For Each Worksheet In ThisWorkbook.Sheets Cells.Select...

Guys I am trying to clean all excels present in a folder and highlight required data in all excels. Using following code for cleaning excels Sub Looper() Dim wb As Workbook Dim myPath As String Dim myFile As String Dim myExtension As String Dim FldrPicker As FileDialog 'Optimize Macro Speed...

Hello Guys, Hope you are doing well today, Can you please assist me in providing the two different functions for each of the below two scenarios Formula required for the below condition for first excel sheet: If B7 = Receipt Amount E7 = Claim Amount · Claim amount = If Receipt...

The purpose of this message is to record my deep appreciation of the helpful assistance extended to me by our Moderator, Joe4. :smile: I recently posted my very first thread and noticed that the paragraph spacing in the top half on my text had been removed after I had pasted it into the 'Your...

Can someone please help me with this one. If column D contains a zero or negative, I need to delete that entire row, then I need to repeat this action on 11 sheets out of 14 on one workbook, in one action. The 3 sheets that are not to be affected are master data sheets, these are named. Master...

hi all, I have column A with some amounts with negative and positive values, column B with alphanumeric values, i have the below code which highlights rows if the negative and positive value sums up to 0. but I need a code which highlights rows if column B is duplicate and sum in column A is 0...

Hello All, i want to create 2 or 3 coloumn like blank by using access query or simulant coloumn expression should be in "Double" i tried to try it but go in vain. when i create it, expression becomes in "Benary" but i want it as "Double" Pls suggest me