+ Reply to Thread
Results 1 to 4 of 4

How to insert rows in excel file having 380 worksheets

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    242

    How to insert rows in excel file having 380 worksheets

    Dear friends,

    In my excel file, there are identical 380 worksheets.

    When I select few worksheets (Group worksheets) and try to insert 5 rows after row 380, I am unable to insert rows in the file.
    Can u please assist ?

    I am using desktop i7, 16GM RAM, 64 bit operating system, MS office 2010. The size of file is approx. 60mb.

    Even VBA code would be useful.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,998

    Re: How to insert rows in excel file having 380 worksheets

    If you have 380 worksheets in our file, that is probably 378 too many sheets!

    What on earth do you need so many sheets for - and how the heck do you navigate through them??
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    242

    Re: How to insert rows in excel file having 380 worksheets

    There are approx. 375 outlets for which we need to track their data.
    I have summaried the data in separate worksheet for my tracking and control.

    Please assist.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,998

    Re: How to insert rows in excel file having 380 worksheets

    The generally accepted method of recording data in excel is to have ALL data on 1 sheet, then use other sheets to extract the data/summaries as needed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 05-16-2017, 09:36 AM
  2. [SOLVED] vba insert empty rows into worksheets
    By vio.coman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2014, 07:25 AM
  3. Replies: 16
    Last Post: 07-22-2013, 10:01 PM
  4. Linked Worksheets auto insert rows
    By JohnHagan1 in forum Excel General
    Replies: 3
    Last Post: 02-07-2013, 03:01 PM
  5. Insert/Delete rows across worksheets
    By jeffreybrown in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-28-2011, 03:01 PM
  6. linking worksheets to auto-insert rows
    By rbatkie in forum Excel General
    Replies: 1
    Last Post: 02-28-2007, 12:04 PM
  7. [SOLVED] insert or delete rows across multiple worksheets?
    By BobW in forum Excel General
    Replies: 1
    Last Post: 02-16-2006, 01:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1