+ Reply to Thread
Results 1 to 1 of 1

Formatting issue - Inserting variable rows

  1. #1
    Registered User
    Join Date
    08-25-2010
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2003
    Posts
    7

    Formatting issue - Inserting variable rows

    Hi, I'm long time lurker who finally got round to joining

    I知 trying to build a spreadsheet to sort data to a certain format. Each week I receive a spreadsheet with data in one format (always the same layout) and in order to use that data I need to alter the format substantially; as there are several hundred files on the incoming spreadsheet using Excel to sort the data is ideal.

    I知 not too clued up on the terminology but basically what I need to do is insert a variable number of rows after each unique record (based on an account number in column A) to bring the total number of rows with that account number to 10. (I.e. if account 0001 in has one record I need to insert nine rows after it, if account 0002 had four records I need to insert 6 rows after it)

    I have no idea how to get excel to identify the number rows with an account number in and then insert the necessary rows afterwards, I知 not sure if what I知 asking is even possible, if it isn稚 then I知 sure someone here can tell me!

    The new rows must be totally blank except for column A which needs the account number in, I致e attached an 礎efore spreadsheet with an example of how the data looks when it comes in and a 疎fter spreadsheet showing how I need the spreadsheet to look after it痴 formatted ideally I壇 like to run the formatting using a macro, that way I can keep the spreadsheet and just copy the incoming data in each week to sort it before copying it out again.

    The major problem I have is that although the data comes in the same layout each week the number of rows for each account is variable, obviously this means that one week I might need to insert 4 rows after the first account on the spreadsheet but the next week I might only need to insert 1.

    Thanks in advance for your help!
    Attached Files Attached Files

+ Reply to Thread

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