+ Reply to Thread
Results 1 to 2 of 2

How to fill multiple cells in a raw based on a start and end values

  1. 03-19-2015, 07:39 AM #1
    atchorizon
    atchorizon is offline
    Registered User
    Join Date
    02-13-2015
    Location
    Johannesburg
    MS-Off Ver
    office 2013
    Posts
    11

    How to fill multiple cells in a raw based on a start and end values

    If anybody can help me here.. I’m looking for a way to get consecutive cells in a raw filled with asterisk based on some values specified in two other cells. Let us assume a set of adjacent cells B2:Y2, I want to get those cells filled up with asterisk symbol based on values specified in cells AA3 and AB3 starting from AA3 value ending at AB3 value. For example, if AA3=4 and AB3=16, so I want the asterisk symbol to show on all cells starting from E2 to Q2.
    You kind assistance is highly appreciated.. thanks in advance
    Reply With QuoteRegister To Reply
  2. 03-20-2015, 01:08 AM #2
    tuph
    tuph is offline
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: How to fill multiple cells in a raw based on a start and end values

    Please attache a sample of your workbook so no-one has to re-create your data to find a solution. Remember to remove any sensitive info before uploading the file.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved

    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments
    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)

Similar Threads

  1. Color a timeline based on start and end values in two cells
    By Schmoranz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2014, 09:23 AM
  2. [SOLVED] Select a range of rows based on start row and end row being values in two worksheet cells
    By xlnube in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2012, 08:41 PM
  3. Auto-fill adjacent cells based on start/stop date?
    By jeffreyray in forum Excel General
    Replies: 3
    Last Post: 10-03-2011, 06:49 PM
  4. Fill cells based upon values
    By chrisnat in forum Excel General
    Replies: 2
    Last Post: 03-28-2011, 09:23 AM
  5. Fill in cells based on other cell values
    By BrettW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2009, 11:46 AM

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