Results 1 to 7 of 7

Auto-populate cells if other cells meet a criteria

Threaded View

Shirora Auto-populate cells if other... 10-29-2019, 03:15 PM
Pete_UK Re: Auto-populate cells if... 10-29-2019, 04:17 PM
Shirora Re: Auto-populate cells if... 10-29-2019, 06:36 PM
Pete_UK Re: Auto-populate cells if... 10-29-2019, 09:50 PM
Shirora Re: Auto-populate cells if... 10-30-2019, 11:58 AM
  1. #1
    Registered User
    Join Date
    11-25-2017
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    4

    Auto-populate cells if other cells meet a criteria

    Hi! I'm a novice on excel trying to auto-populate some cells.

    I have a row with dates (going weekly) and I want to be able to return specific cells under these dates if today's date fall under the week displayed.

    Ex: I want to return the data in F9 to A11 and F11 to B11 since we are in the week of Oct 28 and there are items in the cells under it. Now if we move from the week of Oct 28 to Nov 4, I'd like the formula to retun what is in G9 to A11 and blank out B11, C11 and D11 since there is nothing there for that week.

    Please see attached example file. Thanks everyone for helping me out with this
    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. [SOLVED] Auto Populate Cells Based on a Criteria
    By danallamas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2017, 08:06 PM
  2. [SOLVED] Macro to clear cells in range & move up if certain cells meet criteria
    By samder68 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2016, 10:52 PM
  3. [SOLVED] Formula to auto populate cells to match multiple tabs with certain criteria
    By rowena229 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-18-2015, 04:42 PM
  4. Geomean last 5 cells where adjacent cells meet certain criteria
    By thomasart23 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-06-2014, 05:03 PM
  5. Replies: 5
    Last Post: 05-18-2013, 07:49 PM
  6. Replies: 14
    Last Post: 04-19-2011, 02:22 PM
  7. Replies: 15
    Last Post: 02-19-2011, 12:40 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