Results 1 to 6 of 6

Thread: Excell Formula (Help)

  1. #1
    mihmay is offline Senior Member+
    Last Online
    5th April 2014 @ 11:53 AM
    Join Date
    28 Mar 2009
    Age
    39
    Posts
    278
    Threads
    88
    Credits
    970
    Thanked
    3

    Default Excell Formula (Help)

    Mere paas excell ki ek sheet hai jis k 3000 se ziada rows hain or mujhe har ek roq k baad ek row k space dena hai jo Insert Row k zarye karta hain but itnay saary karnay mai time bohat ziada lag jai ga....agar koi formula hai to plz mujhe bata dain.....I m waiting....

  2. #2
    mihmay is offline Senior Member+
    Last Online
    5th April 2014 @ 11:53 AM
    Join Date
    28 Mar 2009
    Age
    39
    Posts
    278
    Threads
    88
    Credits
    970
    Thanked
    3

    Default

    Plz any one rpl me.....I m waiting.....

  3. #3
    Rashid Jan's Avatar
    Rashid Jan is offline Advance Member
    Last Online
    25th December 2022 @ 04:34 AM
    Join Date
    20 Jul 2008
    Location
    ur Dreams
    Age
    35
    Gender
    Male
    Posts
    3,889
    Threads
    49
    Credits
    85
    Thanked
    70

    Default

    bhai jan ap ki baat samjh me nahe aae aap apni excell ki sheet attech kare me wo dekh kar aap ko us ka hal bataon yahan aap ki detail nahe he apne sirf space ki baat ki he thora ziyada detail karen to inshallah ap ki help karen gae

  4. #4
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    try the following Macro. Follow the following steps.

    1. press ALT+F11
    2. INsert Menue m ja kar Module select karain.
    3. Below code ko paste karain.
    --------------------------------
    Sub InsRows()
    Dim LR As Long, i As Long, j As Integer
    LR = Cells(Rows.Count, "A").End(xlUp).Row
    For i = LR To 2 Step -1
    Rows(i).Insert
    Next i
    End Sub
    ---------------------------------------

    Please original sheet par test karne se pehle aapni file k copy bana lain. Phir test karain.
    Ye 10-15 second k time la ga aur har row k neeche new row add ho gae ge.

    I assume k aap ka data column "A" se start hota ha. Agar nahee tu "A" ko apne matlooba column k name se change kar dain
    Koi problem ho tu please reply.

    regards.

  5. #5
    imranjhang's Avatar
    imranjhang is offline Senior Member+
    Last Online
    11th May 2021 @ 02:36 PM
    Join Date
    17 Dec 2009
    Age
    38
    Posts
    94
    Threads
    1
    Credits
    1,390
    Thanked
    13

    Default

    Quote syar said: View Post


    try the following Macro. Follow the following steps.

    1. press ALT+F11
    2. INsert Menue m ja kar Module select karain.
    3. Below code ko paste karain.
    --------------------------------
    Sub InsRows()
    Dim LR As Long, i As Long, j As Integer
    LR = Cells(Rows.Count, "A").End(xlUp).Row
    For i = LR To 2 Step -1
    Rows(i).Insert
    Next i
    End Sub
    ---------------------------------------

    Please original sheet par test karne se pehle aapni file k copy bana lain. Phir test karain.
    Ye 10-15 second k time la ga aur har row k neeche new row add ho gae ge.

    I assume k aap ka data column "A" se start hota ha. Agar nahee tu "A" ko apne matlooba column k name se change kar dain
    Koi problem ho tu please reply.

    regards.
    Bilkul theek

  6. #6
    mihmay is offline Senior Member+
    Last Online
    5th April 2014 @ 11:53 AM
    Join Date
    28 Mar 2009
    Age
    39
    Posts
    278
    Threads
    88
    Credits
    970
    Thanked
    3

    Default

    Thnx main chgeck karta hoooon.....Thanx for ur Cooperation & Support.

Similar Threads

  1. Excell may Overtime ka formula lagana hay
    By zahid4942 in forum Ask an Expert
    Replies: 2
    Last Post: 6th September 2014, 05:39 PM
  2. Solved excell formula chahye
    By lvdeeds in forum Solved Problems (IT)
    Replies: 27
    Last Post: 13th January 2012, 03:31 PM
  3. need help in excell.
    By jaadoogar in forum Ask an Expert
    Replies: 3
    Last Post: 9th December 2010, 01:21 PM
  4. Excell formula need
    By lvdeeds in forum Ask an Expert
    Replies: 7
    Last Post: 24th March 2009, 09:40 AM
  5. need excell Help
    By lvdeeds in forum Ask an Expert
    Replies: 14
    Last Post: 21st March 2009, 12:45 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
  •