hi friends,
I have one doubt in time calculated formula.
I enclosed the sample file for your reference, I have given the slab and time please help on same.
Regards
Jawahar P
Hi Team,
we have date with Time in A & B Coloums result in C Coloum A-B in C
if Day <=24 should updated "Y" or "N" enclosed sample data for reference
Please help on same
Thanks
Jawahar Prem
Hi Team,
Conduction
if camp P2P and days <=90" should updated as "A"
if camp MNPand days <=120" should updated as "A"
I tried in OR,AND,XOR please I not getting proper output please help on same. sample data enclosed for reference.
Thanks Jawahar
Hi,
Please help me this macro
1. in master base Q column need to take only <> null and paste in "calling sheet", "B column"
(need to take only Q column not overall data)
2. in "calling sheet" need to map the cust_name1 & cust_name2 from "mapping sheet" using "G Coloum"
3. in "calling sheet"...
Hi,
thanks for your time,
i have tried this macro by getting some error can u please help on same file enclosed for reference.
Option Explicit
Sub copyrows()
Dim lRow As Long
Dim lCol As Integer
Application.ScreenUpdating = False
Sheets("Master Base").Select
lRow = Cells.Find("*"...
Hi,
i need a vba code for mentioned critra.
1. in master base @ coloum C only "AA" & "AAA" should move sheet named C
2. in master base @ coloum D only "AA" & "AAA" should move sheet named D
After moving i need a vlookup with C & D sheet againts "ALLOC" sheets ref the the coloum names...
Hi All,
Please help on this query, i need to know which employess are comming late from their loging time, if the emp login time is 9.30 while he reaches by 9.40 in rem coloum a text should to display as Late commer or on time. i enclosed sample file for your reference.
Thanks
Jawahar Prem
Hi Asheesh,
Thanks for your time, i have worked on this but i not getting the proper output, i enclosed the file and updated the remarks to understand, Please help on this.
thanks
jawahar prem
Hi All,
please help in date calculation formula details given and file enclosed for reference.
1. i have offer Validaity month in B Coloum,
offer act date F Coloum and BC Date in D coloum
Now what i nedd to find out the offer closing date
Ex - 1st Case - offer month 4, Offer act date is on...
Hi,
i need help on this.
REQ - need to find the days between previous call and present call,
i have enclosed number and date, if number are same need to calculate previous date and last data to find days between.
enclosed file for reference.
Thanks
Jawahar Prem
Hi,
in my file while iam change the dashboard, chart should change as data
Ex if i select apr month data change should take april data, if may it should take may's.
i enclosed my excel file format for reference.
Thanks
Jawahar Prem
Hi All,
in my sheet2 range(P6:Z23) dashboard, when i select april radio button the dashboard should paste in same fomate in ("b6) iam not getting proper output while iam running this code please help on same. excel file enclosed for reference..
Sub OptionButton1_Click()
Rows("6:23").Select...
Hi All,
Please help on this code.
i have a date in "J coloum" if Previous Month Ex "dec" data should be calculate from
"C to I", and updated in k coloum.
if current Month Ex "jan" data should be calculate from
"D to I", and updated in k coloum.
i enclosed sample file for your reference...