+ Reply to Thread
Results 1 to 20 of 20

Copy numbers to fill in blanks

Hybrid View

  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    Newark, DE
    MS-Off Ver
    Excel 2007
    Posts
    91

    Re: Copy numbers to fill in blanks

    I figured it out. Very sloppy but it worked. I added in Column A, the values of H on all lines that had a number and L on all of the blank rows. Then I used =IF(AND(A2="H")B2,"") which I copied down to all of the blanks. That filled in all of the second blank lines. Then I used =IF(AND(A6="H"),B6,B5) on the remaining blanks and those were filled in. Like I said, the hard way but at least I got where I was going. Thanks!!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Copy numbers to fill in blanks

    I kind of like Martin's macro in post #2.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. fill in the blanks
    By pmugagga in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-07-2013, 10:54 AM
  2. Scan a Column A (numbers and blanks) and copy its contents WITHOUT BLANKS into Column B
    By bighandsam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2012, 05:16 PM
  3. Copy and fill cells with existing numbers
    By Vestlink in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2012, 08:21 AM
  4. to fill in the blanks on a Pivot table without using copy and paste
    By oasalako1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2012, 01:51 PM
  5. Fill Blanks
    By VBA Noob in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-20-2006, 05:06 AM
  6. Fill in the blanks!
    By Bhupinder Rayat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2006, 12:50 PM
  7. Fill in the blanks!
    By Bhupinder Rayat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2006, 12:50 PM
  8. Copy selected cell in column and fill in blanks
    By Bluestar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2005, 10:28 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