Results 1 to 4 of 4

populate list on one tab by taking rows from another tab only with data in certain columns

Threaded View

  1. #1
    Registered User
    Join Date
    10-23-2019
    Location
    Oakland
    MS-Off Ver
    Professional Plus 2016
    Posts
    10

    populate list on one tab by taking rows from another tab only with data in certain columns

    Hi all - thanks in advance for any help on this:

    I want to setup the tab "Item Format" so that it automatically populates from only rows that have data in AA through AG on "Worksheet". The "worksheet" tab is set to include data in columns AA through AG only if the value in column H is within 60% of the value of H3. So the rows that will be included in "item format" will change depending on the example's value in H3.

    For instance, in this example only rows 5 and 9 have data in AA through AG because H5 and H9 are within 60% of H3.

    So in this example 'worksheet'!AA5 should populate 'item format'!G7 and 'worksheet'!AA9 should populate 'item format'!G8.

    Cheers
    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. Replies: 7
    Last Post: 02-05-2015, 03:20 PM
  2. Replies: 7
    Last Post: 08-05-2014, 05:34 AM
  3. Replies: 7
    Last Post: 06-12-2013, 07:09 PM
  4. Macro to populate Data from Columns into Rows.
    By Pitsere in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2013, 08:21 AM
  5. Taking data in rows and stacking into columns
    By jcoe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-22-2013, 05:50 AM
  6. Populate Rows and Columns - List?
    By phillyg21 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2013, 10:34 AM
  7. Query to populate data from rows to columns
    By tscott in forum Access Tables & Databases
    Replies: 6
    Last Post: 03-05-2011, 07:32 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