Posts by misprepaid.asm

    HI,


    I have an excel sheet with two fields...sheet name is ..."Addresses"..
    A1:= Employee_mail_id
    B1:= Leave_balance


    What I need to do is that.I need to send individual mail two each employee intimating their leave balances.
    Is it possible to do it in vb .I want it to assingn the codes in a button.


    If this is possible in MSaccess also..It will be ok.


    Please help guys...

    Re: Get the next possible larger value next to the current value


    Quote from StephenR;650189

    misprepaid.asm: please don't treat people answering questions here as if they were your lackeys. And take the time to set out all the details of your question at the beginning - this avoids all concerned wasting time.




    I apologize for my mistake..I will surely keep in mind from this thime onwards.

    Hi,


    I have a data where I want to create a formula fulfilling the below conditions.


    Suppose I have two fields: Table1(A) and Table2(B)
    If a value ex.98 (A COLUMN) matches with the value with 98(B COLUMN),it should pick up my second higher value 103. suppose 103 is the next high value of 98 .


    [TABLE="width: 903"]

    [tr]


    [td]

    TABLE1

    [/td]


    [td]

    TABLE2

    [/td]


    [td][/td]


    [td]

    Required Result

    [/td]


    [td]

    Condition

    [/td]


    [td]

    OUTPUT

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]98[/TD]
    [TD="align: right"]98[/TD]

    [td][/td]


    [td]

    98 then 103

    [/td]


    [td]

    if value of table1=98 then 103from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]103[/TD]
    [TD="align: right"]103[/TD]

    [td][/td]


    [td]

    103 then 149

    [/td]


    [td]

    if value of table1=103 then 149from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]149[/TD]
    [TD="align: right"]149[/TD]

    [td][/td]


    [td]

    149 then 175

    [/td]


    [td]

    if value of table1=149 then 175from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]175[/TD]
    [TD="align: right"]175[/TD]

    [td][/td]


    [td]

    175 then 198

    [/td]


    [td]

    if value of table1=175 then 198from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]198[/TD]
    [TD="align: right"]198[/TD]

    [td][/td]


    [td]

    198 then 199

    [/td]


    [td]

    if value of table1=198 then 199from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]199[/TD]
    [TD="align: right"]199[/TD]

    [td][/td]


    [td]

    199 then 201

    [/td]


    [td]

    if value of table1=199 then 201from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]201[/TD]
    [TD="align: right"]201[/TD]

    [td][/td]


    [td]

    201 then 245

    [/td]


    [td]

    if value of table1=201 then 245from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]245[/TD]
    [TD="align: right"]245[/TD]

    [td][/td]


    [td]

    245 then 251

    [/td]


    [td]

    if value of table1=245 then 251from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]251[/TD]
    [TD="align: right"]251[/TD]

    [td][/td]


    [td]

    251 then 351

    [/td]


    [td]

    if value of table1=251 then 351from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]351[/TD]
    [TD="align: right"]351[/TD]

    [td][/td]


    [td]

    351 then 352

    [/td]


    [td]

    if value of table1=351 then 352from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]352[/TD]
    [TD="align: right"]352[/TD]

    [td][/td]


    [td]

    352 then 451

    [/td]


    [td]

    if value of table1=352 then 451from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]451[/TD]
    [TD="align: right"]451[/TD]

    [td][/td]


    [td]

    451 then 499

    [/td]


    [td]

    if value of table1=451 then 499from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]499[/TD]
    [TD="align: right"]499[/TD]

    [td][/td]


    [td]

    499 then 598

    [/td]


    [td]

    if value of table1=499 then 598from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]598[/TD]
    [TD="align: right"]598[/TD]

    [td][/td]


    [td]

    598 then 599

    [/td]


    [td]

    if value of table1=598 then 599from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]599[/TD]
    [TD="align: right"]599[/TD]

    [td][/td]


    [td]

    599 then 601

    [/td]


    [td]

    if value of table1=599 then 601from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]601[/TD]
    [TD="align: right"]601[/TD]

    [td][/td]


    [td]

    601 then 751

    [/td]


    [td]

    if value of table1=601 then 751from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]751[/TD]
    [TD="align: right"]751[/TD]

    [td][/td]


    [td]

    751 then 851

    [/td]


    [td]

    if value of table1=751 then 851from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]851[/TD]
    [TD="align: right"]851[/TD]

    [td][/td]


    [td]

    851 then 949

    [/td]


    [td]

    if value of table1=851 then 949from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]949[/TD]
    [TD="align: right"]949[/TD]

    [td][/td]


    [td]

    949 then 951

    [/td]


    [td]

    if value of table1=949 then 951from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]951[/TD]
    [TD="align: right"]951[/TD]

    [td][/td]


    [td]

    951 then 1251

    [/td]


    [td]

    if value of table1=951 then 1251from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]1251[/TD]
    [TD="align: right"]1251[/TD]

    [td][/td]


    [td]

    1251 then 1501

    [/td]


    [td]

    if value of table1=1251 then 1501from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: right"]1501[/TD]
    [TD="align: right"]1501[/TD]

    [td][/td]


    [td]

    1501 then 1501

    [/td]


    [td]

    if value of table1=1501 then 1501from table 2 (next large number)

    [/td]


    [td][/td]


    [/tr]


    [/TABLE]

    Hi,

    Please help me in looking up the value in a date range. as i have a huge data to map.
    Suppose

    [TABLE="width: 219"]

    [tr]


    [td]

    Source data

    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="colspan: 2"]DATE RANGE
    [/TD]

    [td][/td]


    [/tr]


    [tr]


    [td]

    FROM DATE

    [/td]


    [td]

    TO DATE

    [/td]


    [td]

    VALUE

    [/td]


    [/tr]


    [tr]


    [td]

    1-Jan-12

    [/td]


    [td]

    10-Jan-12

    [/td]


    [td]

    250

    [/td]


    [/tr]


    [tr]


    [td]

    25-Jan-12

    [/td]


    [td]

    5-Feb-12

    [/td]


    [td]

    100

    [/td]


    [/tr]


    [tr]


    [td]

    12-Mar-12

    [/td]


    [td]

    18-Mar-12

    [/td]


    [td]

    200

    [/td]


    [/tr]


    [/TABLE]


    [TABLE="width: 216"]

    [tr]


    [td]

    required data

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    MY DATE

    [/td]


    [td]

    REQUIRED OUTPUT

    [/td]


    [/tr]


    [tr]


    [td]

    17-Mar-12

    [/td]


    [td]

    200

    [/td]


    [/tr]


    [tr]


    [td]

    2-Jan-12

    [/td]


    [td]

    250

    [/td]


    [/tr]


    [tr]


    [td]

    5-Jan-12

    [/td]


    [td]

    250

    [/td]


    [/tr]


    [tr]


    [td]

    15-Mar-12

    [/td]


    [td]

    200

    [/td]


    [/tr]


    [tr]


    [td]

    1-Feb-12

    [/td]


    [td]

    100

    [/td]


    [/tr]


    [/TABLE]

    I need to align these data in to rows in Excel using VBA.I have a huge data in this format. I need to make it into rows.
    Suppose,the data is pasted in sheet1 in Cell A1. My requirement is 1.where it find the string“IMSI” (Suppose IMSI string is in cell A2),I need the A3 data in B3 Cell. 2. where it find the string “DATE” (Suppose DATE string is in cell A5),I need the A3 data in C5 Cell. 2. where it find the string “IMEI” (Suppose IMEI string is in cell A9),I need the A3 data in D9 Cell. Similarly it should loop for all data and make it in rows.

    Please check the attachment for further details.


    SUBSCRIBER DETAILS IMSI MSISDN STATE 405845001382775 919085919027 IDLE DATE TIME CELLID 130103 122725 404-29-12906-15353 IMEI 356395024630200 SUBSCRIBER DETAILS IMSI MSISDN STATE 405845002463183 919085325090 IDET DATE TIME CELLID 130103 103447 404-29-12107-23993 IMEI 354917031429730 Required output:-

    IMSI MSISDN STATE DATE TIME CELLID DATE TIME CELLID IMEI 405845001382775 919085919027 IDLE 130103 122725 404-29-12906-15353 356395024630200 IMSI MSISDN STATE DATE TIME CELLID DATE TIME CELLID IMEI 405845002463183 919085325090 IDET 130103 103447