Search results

Came across this formula, Can this formula be converted to use DATEIFF instead of Networkdays. Networkdays days doesn't work in THIRD PARTY APPLICATION =ROUND((NETWORKDAYS(A3,B3)*8)-IF(WEEKDAY(A3,2)>=6,0,MIN(MAX(24*(MOD(A3,1)-"9:00"),0),8)) -...

@ Jindon.. Thank you much ..Simply awesome coding. Part 2 - Doesn't work. Tried to understand your code..It's v hi tech for me. Basically, Need to extract columns based on vendor name and month Attached sample file for ref. Thanks again for your time.

@jindon Any help on this request?

@vletm Sorry No...Have that format for a specific reason...putting together a project with puzzles.. That's the reason require user input in J20 and as user's also if needed will be adding rows or deleting rows between row5 to to row 20. If rows added/deleted - J20 cell must always be...

@vletm Have other header files and data above row 5 in my original file, So can't have user input cell on top. - If user adds a row between row 5 and 20, The "J20" cell must also move down (where user inputs number) Thanks for assisting again..

Correct - Exisiting code will not work attached in test file .So needs to modified with your expertise. - If user adds a row between row 5 and 20, The "J20" cell must also move down (where user inputs number) See attached file

@vletm If any row inserted , Breaks the code for J20 Is there a way to always reference that cell to input hours

Hello , Couldn't find needed in above link. Need help with a FORMULA to extract Total number of OFF business hours from provided start and end time. Weekday OFF business hours (mon -Fri ) 5pm - 9am Weekend OFF business hours = Friday 5pm to monday 9AM Test file attached

@vletm Excellentae... Thank you much....

@jindon Hello, Have couple more request to add to current code 1. Total for all months in column B - Attached test file and sample output in row 17 to 24 2. extract report by vendor (Have dropdown in cell B29 ,C29 and D29 and sample output file in row 30 to 42 drop down has vendor names ...

@vetlm Have highlighted in red for incorrect output and highligted in green for reqd. results and commented for details. Require Formula j27/j$41 integrated in macro for col K range Note : ROW 26 TO 44 is for reference only- example of output reqd. Actual file to test starts from row 5 to...

Thanks... I give up with this thread..Its not what am looking for. Please read my first post

@vletm.. Doesn't work. Still adding numbers in your sheet column J22 Only change reqd. in col K to calculate based on adjacent col J cell by dividing cell " J20" If you're testin , Please use the attached test file and code. Private Sub Worksheet_Change(ByVal Target As Range) ay =...

@vletm 1) Why do You use .xlsx-files? then no Macros! No calculations! For some reason - was unable to upload macro file, so have saved in .xlsx and posted code in thread. 2) Is that Yellow [J20] or [J41] ALWAYS fixed (120)? - Yellow "J20" and 120 is not always fixed (User inputs that number...

@vletm Test file is attached to the first post (Test drop.xlsx) and code above works for my layout for the attached file. Rattaching file.. Only change reqd. in col K to calculate based on adjacent col J cell and divide by cell " J20" let me know..If you're unable to download test file.

@ vletm ...Need values in col k , but calculations in col K is incorrect. Code worksheetfunction is suming up the range j6 :j9 Require in col K to calculate based on adjacent col j cell and divide by col J20 @Marc L .. I did try the formula before posting query, the code above overwrites the...

Hi, Require assistance to modify code below As data is entered in column J6 : J19 cells , each cell in Column K to divide J6 :J19 by " J20" Example : J20 has data= 120 user inputs in J6 as 10 Column K6 result = J6/J20 user inputs in J7 as 20 Column K7 result = J7/J20 and so on... Much...

Hi , Any help ? Looking for formula to extract ONLY Off hours between 2 given dates and times Off hours Weekdays Mon 5pm to next day 9am Off hours Weekend (Friday- 5pm to 9am Monday) format of dates: m/d/yyyy h:mm See attached file for ref.

Thanks for your help ..That's not the requirement Maybe am not able to explain properly - Sample file attached for ref. Have a drop down for month in J5 cell and data is entered based on month in below cells J6:J21 and data is calculated in col K using formula(=J6/J$22). Require ONLY column...

@vetlm... Based on dropdown month - data entered in column J and data is changed in column K (on a formula) - need to ONLY copy data over from J and K to respective months/column J K% data copy over to L M% FOR JAN and so on.

@vletm ..Thanks . Tried to modify code on attached sample sheet. Not sure..what field is being missed. Private Sub Worksheet_Change(ByVal Target As Range) ay = Target.Row ax = Target.Column If ax = 10 Then Application.ScreenUpdating = False Application.EnableEvents...

@vletm ..Columns have moved and data to be written in alternate columns. Please see attached file to initial thread... Require column K data copied over to month (Col L for Jan) and if another month selected in col J5 must add data accordingly to other months columns respectively. - Require...

Hi Have a drop down for month in J5 cell and data is entered based on month in below cells J6:J21 and data calculated in col K using formula. Require column K data copied over to month (Col L for Jan) and if another month selected in col J5 must add data accordingly to other months columns...

@jindon .. Awesome Super Like ..Thank you again for your time.

@jindon .. Was able to modify the code for moved columns Require additional fields to be added to output field - please see attached file. Thanks for your help Sub test() Dim ws As Worksheet, a, i As Long, ii As Long, dic As Object, w Set dic = CreateObject("Scripting.Dictionary")...