+ Reply to Thread
Results 1 to 6 of 6

Fill Series of Disjointed Selection across Rows & Columns?

  1. #1
    Registered User
    Join Date
    10-01-2008
    Location
    Home
    Posts
    3

    Fill Series of Disjointed Selection across Rows & Columns?

    How can I quickly finish numbering the white boxes in this spread sheet?

    http://i34.tinypic.com/33y6pgm.jpg

    Thank you very much.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Welcome to the forum.

    Can we buy a clue?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-01-2008
    Location
    Home
    Posts
    3
    Sorry, I just need to number the empty boxes 1, 2, 3, 4 ... across the rows and start the next row with 5, 6, 7 ... This is shown in the picture in the first post.

    Unfortunately, there are blank spaces in between so I can not use the Fill Series option of clicking and dragging the black cross.

    The sheet represents a group of parts that are ordered in that fashion on a circular platform, the blue spaces are bad parts.

    I'm looking for an easy way to number the good parts, as described above.
    It seems that I should be able to select the cells of the good parts and quickly number them using a function of sorts, perhaps?

    Any help would be greatly appreciated.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    I think you need a macro:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-01-2008
    Location
    Home
    Posts
    3
    That doesn't seem to work, each new selection starts at 1.

    Perhaps I'm selecting them wrong? (Holding Ctrl, then clicking and dragging across each row.) I'm not sure how to go about fixing the code, eek.

    Thank you.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Please Login or Register  to view this content.

+ 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. Hide Rows based on dropdown selection...
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2008, 04:09 PM
  2. how to toggle the 'visible' property of a series
    By arioti in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-08-2007, 10:05 AM
  3. Switching columns to rows
    By Paige in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2007, 05:38 PM
  4. Hide or erase unused rows and columns
    By MaxAlbertsson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2007, 07:52 AM
  5. Re-arranging columns and rows
    By wbank in forum Excel General
    Replies: 2
    Last Post: 07-18-2007, 05:25 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