Results 1 to 4 of 4

Insert / Delete Rows depending upon Dynamic Built Table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Question Insert / Delete Rows depending upon Dynamic Built Table

    I have a long macro that builds a heavily formatted table and builds it under headers within a table located at a dynamic spot. The user will input data into userforms which determinds how big / small this built table will be. Sometimes it might be bigger than the "open" cells / rows and sometimes it might be smaller than the open cells. When I say open cells, I mean the open or blank rows between the headers and the TEXT data that I have below the table. This text data will always be there.

    All I want is the "TEXT" data to move and always be (2) rows below the data that is entered from the macro.

    So I need to insert / delete rows depending upon how big /small the built table is and depending upon how many open cells there are when the user opens the worksheet, as that number will be different each time they open it.


    And I cant just copy and paste , (or have a macro "move" the text data) because that text data is heavily formatted with merged cells and other items. It is basically a word document brought over into excel.


    I have a sample document that shows just what I am talking about. Sheet 1 is all there is to work with. The other tabs are examples of "results" that would result when the macro would finish.

    Thanks SOOO MUCH for looking at this.
    Attached Files Attached Files
    Last edited by clemsoncooz; 02-10-2012 at 11:45 AM.

Thread Information

Users Browsing this Thread

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

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