Results 1 to 1 of 1

Fill in blocks to get numbers on another sheet

Threaded View

cymruchic Fill in blocks to get numbers... 10-27-2015, 10:11 PM
  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    wales
    MS-Off Ver
    latest
    Posts
    86

    Fill in blocks to get numbers on another sheet

    I need to be able to manually select a number of cells in the implementation tab and fill them in black. Upon doing this i need the corresponding row to have the cell numbers in them.

    For instance if you were to type 5 and 6 in the cat5 tab on row 1 in the next two cells it will show as a black block on the implantation tab as 5 and 6. I need to able to reverse this, instead of typing the numbers i need to be able to fill in the cells on implementation 5 and 5.5 and it put the numbers 5 and 5.5 on the cat 5 tab. I need to be able to do tthis on every row and column
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fill an incremental time entry in blocks of 4 rows
    By suedavies in forum Excel General
    Replies: 4
    Last Post: 04-08-2014, 04:01 PM
  2. Macro auto-fill: Blocks of consecutive decimal numbers with blank row in between them
    By markbs123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2014, 07:04 AM
  3. Macro to fill in signature and date blocks
    By Hambone70 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2013, 11:09 AM
  4. Summing blocks of 96 numbers
    By bortap in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2013, 11:16 AM
  5. Blocks of Cells and Color Fill
    By MrDubleTruble in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2010, 03:36 PM
  6. Fill series that combines data from 2 sheets in blocks of 10
    By dannyfromnj in forum Excel General
    Replies: 5
    Last Post: 06-05-2006, 12:10 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