+ Reply to Thread
Results 1 to 3 of 3

Repeat data in blank cells

  1. #1
    Registered User
    Join Date
    02-06-2008
    Posts
    1

    Repeat data in blank cells

    I am trying to figure out a formula that fills in blank cells by repeating the the contents of the above cell . The spreadsheet has several rows of data, a sample of the data is as follows:
    Ref Name £
    12 J Bloggs 1234
    blank blank 2241
    14 G Smith 3251
    blank blank 3568
    blank blank 5126
    15 D Garry 1334

    I am wanting have the following result but without having to manually copy and paste the Ref and Name down each time there is a gap:
    Ref Name £
    12 J Bloggs 1234
    12 J Bloggs 2241
    14 G Smith 3251
    14 G Smith 3568
    14 G Smith 5126
    15 D Garry 1334

    Does anybody know how to do it ?

  2. #2
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255
    Assuming that your table is in A1 to C7, in a spare column (say D) in cell D2 enter the following formula:-

    =IF(ISBLANK(A2),D1,A2)

    copy this formula down to D7

    In cell E2 enter the following formula:-

    =IF(ISBLANK(B2),E1,B2)

    copy this formula down to E7

    Then copy D2:E7 and paste it to A2:B7, paste as paste special values

    Finally delete D and E

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    See link

    http://www.contextures.com/xlDataEntry02.html

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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