+ Reply to Thread
Results 1 to 3 of 3

Large data set fill problem

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Lincoln, NE
    MS-Off Ver
    Excel 2007
    Posts
    17

    Large data set fill problem

    I use a program that exports data in a format that I can easily use pivot tables with to extract the data that I need. The unfortunate problem is that it also exports in a manner that I have to do a little work with the get into a format that I can use. The main problem is that the files can be in the 10s of thousands of rows with every 10 rows needing to replace blanks with the information in the first row above it. I'm sure there is a macro to do this, but I cannot figure out how to fill, then go down one row and fill again and repeat to the end. I am attaching a sample file. Maybe someone can help me replace the "-" with the data in the row above and then move to the next all the way to the end. Thanks.

    JA Max Min.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Large data set fill problem

    First do a find and replace. Find " - " (be sure to include the blank spaces before and after the hyphen) and replace it with nothing. Then select the two columns (excluding the rows above the top header. Then type ctrl+G and click on 'Special' and select 'Blanks'. Then all the blank cells should be selected. In the first blank cell (A4) type =A3 then hit ctrl+enter. NOT JUST ENTER. Then copy and paste values.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-13-2013
    Location
    Lincoln, NE
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Large data set fill problem

    Thank you. Nice and simple! Worked perfectly!

+ 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. Auto-fill on a large scale
    By shanekerr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2015, 07:25 AM
  2. Problem Help Needed to Filter large data
    By mughal1990 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2015, 01:29 AM
  3. Problem using Autofilter to remove large number of rows of data
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 63
    Last Post: 07-30-2013, 07:32 AM
  4. Compare & Fill Data - Large Data Sets - Question
    By mitko007 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-26-2013, 01:52 AM
  5. Using Large Function & Pulling Adjacent Data (Problem With Duplicates)
    By demonfly100 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2013, 05:24 AM
  6. Sorting problem with large data set
    By Infinity666 in forum Excel General
    Replies: 4
    Last Post: 10-20-2009, 11:56 AM
  7. Transposing large files & changing fill
    By Kearse56 in forum Excel General
    Replies: 0
    Last Post: 08-03-2007, 11:27 AM

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