Search results

@jindon ...Thanks Jindon Total worked. Have a slight change in data columns,moved from original (H and J) to (I and K) in tabs (chel,joh,dav)

@jindon .. Thank you for assisting. After running above macro found that.. 1. Total of each product is incorrect ( Must add total of each product(fruit) from all sheets. 2. Header to start from ROW 2 in "output" sheet 3. Attached is a sample file with only 3 sheets, eventually -i 'll have 10...

hi Macro above doesn't total in column B and also all VENDOR data must start from column C ( If you have a look at sample file attached line 5 and line 8 starts from column E and G .

Hello, Need assistance with macro to extract data from multiple sheets based on matched criteria and sum up the values. All vendor data must start from col (C), Below query copies data to other column if no match in first or second sheet. Hope was able to put my question thru properly...

@vletm ..worked..Thanks

Hi, Macro needed : Have dropdown list with months in(Col B3). Is it possible to save data in other cells(column B4:B15) using dropdown (B3) and retrieved. If any change made in B4 :B15 -data to be saved for the chosen month(B3) Thanks

Hi, Need help to extract data from multiple sheet using formula and total the numbers. Have attached sample test file for ref. Thanks ..

Had seen a post somewhere,Cldn't find it anymore , where dates can be copied in same date number format instead of text. Can this macro be modified to cature current date time in date number format? Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Handler If...

Thanks Chihiro..It worked

Few dates are just example..have more than 300 line of dates and this dates are pulled thru a macro. Formula should help to subtract from text format dates.

Hi, Require excel formula to subtract date\time(In text format column B and C) and give results in Column D (output column) Using =($C4-$B4)*1440 in output column gives #VALUE date format : ddd mmm dd, yyyy - hh:mm AM/PM Date 1 Date 2 Output Sun Jan 11, 2017 - 09:00 AM Sun Jan 11, 2017 -...

Need to keep formula in Colmn M =($L3-$K3)*1440 , reason being users sometimes change date and time in colmn L manually and that reflects in M colmn. The above code works but if user changes date and time manually, doesn't update in Colmn M.

using formula in column M =($L3-$K3)*1440 to subtract

Using above macro and subtracting date\ time, getting wrong data type error in another column. tested manually entering date\time,works fine - but not with above macro.

Changed format to ddd mmm dd, yyyy - hh:mm AM/PM and it works. Thank You

It gives wrong date , Shows as Aug 1 ,2017. Time shown is correct.

Hi, If User types in "Yes" anywhere in Column ranging from G3 : G40 , Is there a macro that it would automatically update\write the current date and time in Column L There is already a date and time in col L for assigned task. (Date format in col L is "ddd mmm dd, yyyy - hh:mm AM/PM") Any...

@Chihiro Thank You ..It works

Hello, Using below Macro to highlight duplicate date\time in column D- Works fine. Challenge i have is to find matching date\time in other column E and highlight with same color as column D. Kindly Assist ...Thank You Sub test3() ' Highlight dup times in col D Dim r As Range, myColor, n As...

Thank You pcosta87 ...It works.

Hello, Require assistance in creating macro to extract data based on matched criteria in Column "E" Number header in "Output" sheet and column A in master sheet "DATA" Columns details that needs to be extracted in "Output" sheet that matches Col A in Sheet "Data" are (Status , START DATE...

Thanks Chihiro ... Your formula works perfectly..had Missed E14 format: [h]:mm

Aha ..With above both formulas , It doesn't calculate after 24 hours D14 : Sat Dec 02, 2016 - 12:30 PM C14 : Thu Dec 01, 2016 - 09:00 AM Gives out 3.30 in E Output reqd. : 27:30

Thanks Chihiro This worked too = MOD(D14-C14,1)

I Need to calculate total hours and minutes between 2 dates in column Cand D and output in E Format of dates in Column C and D : ddd mmm dd, yyyy - hh:mm AM/PM Format of Column E : hh:mm D14 : Sat Dec 02, 2016 - 12:30 PM C14 : Thu Dec 01, 2016 - 09:00 AM Output in Cloumn E14 : hh:mm Help...