+ Reply to Thread
Results 1 to 3 of 3

Filling cells

  1. 03-25-2011, 02:00 PM #1
    dlyliny7203 is offline
    Registered User
    Join Date
    03-25-2011
    Location
    New York, NY
    MS-Off Ver
    Excel for Mac 2008
    Posts
    4

    Smile Filling cells

    Dumb question...I have a 15K row worksheet that was imported from a syndicated sales database. It is auto laid out by retailer name in the first cell of column a, then in column b are all the items of a given brand sold in that retailer. (see attached portion of database for what I mean). I want to pivot table this data so I want the empty cells in Column A populated with the Retailer name at the beginning of each "chunk" without having to drag and drop to fill. What is the best way to do this? Thank you for your assistance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-25-2011, 02:09 PM #2
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Filling cells

    One way.....
    Select your range in column A (i.e A8:A115, you can type it into the name box).

    F5 (GoTo), Special>select blank cells

    Then in the formula bar, type = then CNTRL + Up arrow (in your example, you'll see =A8)

    Then CNTRL Enter. Then Copy and Paste Special Values to remove formula.

    EDIT: I see you are using a MAC. Not sure if there is an equivalent to F5 for GoTo. :/
    Last edited by ChemistB; 03-25-2011 at 03:17 PM.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  3. 03-25-2011, 02:32 PM #3
    day92 is offline
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Filling cells

    Another way is to highlight Column A and run this macro..

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1