+ Reply to Thread
Results 1 to 3 of 3

Auto-fill on a large scale

  1. #1
    Registered User
    Join Date
    05-19-2015
    Location
    Loughborough, England
    MS-Off Ver
    MS 2010
    Posts
    6

    Auto-fill on a large scale

    Hi guys, I've got the following dataset (see attached image) which I'm trying to reconcile. Is there is a simple way to automise filling the blank cells with the cells above them. There's over 2000 rows in this dataset which is why I'm seeking a quicker way that copy and pasting or clicking the bottom right corner of each cell.

    Cheers for the help,

    Shane
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    01-23-2013
    Location
    phoenix, arizona
    MS-Off Ver
    Excel 2012
    Posts
    71

    Re: Auto-fill on a large scale

    The formula is just an example but I'm sure you understand:

    A55: =A54

    Copy A55, select the entire vertical range (I believe selecting the entire column will work), Go To Special (Ctrl+G), select blanks, paste. Then copy and paste special values the entire column.

    Let me know if that works!

  3. #3
    Registered User
    Join Date
    05-19-2015
    Location
    Loughborough, England
    MS-Off Ver
    MS 2010
    Posts
    6

    Re: Auto-fill on a large scale

    Worked a treat! Thank you for the help, much appreciated.

+ 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. large scale data trasnfer help
    By testenglee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2015, 02:28 AM
  2. Using Randbetween on a large scale
    By ryanch69 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-31-2014, 06:31 AM
  3. [SOLVED] XML Import on large scale
    By jaromluker in forum Excel General
    Replies: 9
    Last Post: 06-12-2014, 02:46 PM
  4. Large Scale Find and Replace
    By bian999 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2013, 10:59 AM
  5. Large scale counting
    By rhoknee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2010, 05:17 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