Page 1 of 3 123 LastLast
Results 1 to 12 of 25

Thread: Excel Problem

  1. #1
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default Excel Problem


    all member of IT DUNYA
    mene ye pochna ha k kia aisa possible ha excel me k me ne apni ek sheet bnaye ha ledger ki ma chata hon k jis din b me entry dalo sheet me to automatic date likhi ajaye next coloumn me mjh ko likhni na pare agr koi janta ha to pls mjh ko btao urgently
    waiting.............

  2. #2
    itechnological's Avatar
    itechnological is offline Senior Member+
    Last Online
    30th November 2015 @ 03:14 PM
    Join Date
    30 Sep 2008
    Posts
    64
    Threads
    4
    Credits
    860
    Thanked
    4

    Default

    Use following function, this will give you your desired result:
    =TODAY()
    Or otherwise elaborate your problem exactly.

  3. #3
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    jnab ye to me janta hon m chata ho k me ek bar formula lga don phr agr me ne aj entry dali ha to aj ki date ajye or agr me ne kal nhi enty dali parso dali ha to wohi date aye jis din entry dali ha mjh ko date dalni na pare
    pls any member help me

  4. #4
    marwat's Avatar
    marwat is offline Senior Member+
    Last Online
    16th February 2010 @ 07:46 PM
    Join Date
    21 Apr 2007
    Location
    AWAY FROM MY DE
    Posts
    1,743
    Threads
    106
    Credits
    0
    Thanked
    5

    Default

    AAP KA JO COLUMN DATE KA HAY ,USS KO SELECT KARKEY RIGHT CLICK KARAIN,AUR FORMAT CELL KO KLICK KARAIN.PHIR AIK WINDOW OPEN HOGEE USS MAIN "NUMBER" WALEY TAB MAIN "DATE" KO SELECT KARAIN ,AUR OK KARDAIN.
    AB AAP JAB BEE KOI DATA DALAINGEE,TOU DATE WALEY CELL MAY BAJAYE DATE LIKNEY KE,SIRF OOPER WALEY DATE KO DRAG KARLAIN,TOU DATE AUTOMATIC AAJAYEGEE.

  5. #5
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    ok dear i try it

  6. #6
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    marwat hai me ne kia ha lki jisa me chata hon wesa nhi ho rha pls ap image se smjha do ye check kro pls help me
    Attached Images Attached Images  

  7. #7
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    pls help me any member urgently help me

  8. #8
    Mushii is offline Junior Member
    Last Online
    26th December 2010 @ 03:34 PM
    Join Date
    13 Jul 2009
    Location
    Hyderabad
    Age
    43
    Gender
    Male
    Posts
    25
    Threads
    1
    Credits
    0
    Thanked
    4

    Default

    You can try answer of your question over here.
    .................
    Above mentioned forum is specifically related to excel.

    Regards,
    Mushi
    Last edited by XoOaiL; 3rd August 2009 at 07:52 PM. Reason: forum link not allowed to share

  9. #9
    marwat's Avatar
    marwat is offline Senior Member+
    Last Online
    16th February 2010 @ 07:46 PM
    Join Date
    21 Apr 2007
    Location
    AWAY FROM MY DE
    Posts
    1,743
    Threads
    106
    Credits
    0
    Thanked
    5

    Default

    AAP YE CLEAR KAR DO KE AAP HAR ROW ME NAYA DATE DALNA CHATEY HAIN,YA DO TEEN YA CHAR ROWS MAY AIK HEE DATE DALNA CHATEY HAIN?

  10. #10
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    jaisa me ne thread # 6 me btaya ha 31 date ha me ne aj ki entry dalni ha me chata hon k ek bar formula lgao ph jis din b me entry dalon date automatic show ho us din ki pls help me any member

  11. #11
    habibrahet's Avatar
    habibrahet is offline Advance Member
    Last Online
    25th August 2021 @ 02:33 PM
    Join Date
    30 Nov 2008
    Location
    PaKisTaN
    Gender
    Male
    Posts
    2,041
    Threads
    140
    Credits
    69
    Thanked
    102

    Default

    Quote shahleopak said: View Post
    marwat hai me ne kia ha lki jisa me chata hon wesa nhi ho rha pls ap image se smjha do ye check kro pls help me

    work sheet k codes kholain, or sheet per double click karain, or pad main yeh paist kar dain,

    jaisay he aap cell number C ( C1, C2 ya C3) main koi bhee entry karin gay,
    cell number A main uss din ki date(yani aaj ki date) automatic aa jaey gi.


    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    'Written by Rahet
    If Target.Column = 3 Then
    Target.Offset(0, -2).Value = date()
    End If
    End Sub


    Last edited by habibrahet; 3rd August 2009 at 06:55 PM.
    The Race Is Not Over, Coz I've Not Won Yet.



  12. #12
    shaneee is offline Member
    Last Online
    24th December 2011 @ 03:04 PM
    Join Date
    13 Apr 2009
    Age
    42
    Posts
    86
    Threads
    0
    Thanked
    0

    Default

    SHAHLEOPAK aap ko HABIBRAHET ne bilkul sahi coding batai hai oj aap ko required thi same wohi.

Page 1 of 3 123 LastLast

Similar Threads

  1. Excel problem
    By Qutab in forum Ask an Expert
    Replies: 4
    Last Post: 22nd November 2013, 03:48 PM
  2. Excel Problem
    By Qutab in forum Ask an Expert
    Replies: 17
    Last Post: 18th July 2012, 09:01 PM
  3. excel problem
    By Iqbalpk in forum Ask an Expert
    Replies: 2
    Last Post: 26th May 2012, 09:05 AM
  4. Excel Problem
    By Qutab in forum Ask an Expert
    Replies: 3
    Last Post: 22nd October 2011, 10:16 PM
  5. Excel Problem....
    By Adeawan in forum Ask an Expert
    Replies: 3
    Last Post: 6th March 2009, 06:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •