Results 1 to 6 of 6

Find value in rows (40 cells) and populate in separate page in order

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2024
    Location
    SOUTH AFRICA
    MS-Off Ver
    365
    Posts
    5

    Find value in rows (40 cells) and populate in separate page in order

    Hi

    have a selection of cells to indicate window sizes.

    Screenshot 1(cells to populate) is the summary of many cells. We indicate how many window we require per job on screenshot 2(array of cells). Not these tables, cells etc is on same page. Issue is to search true values through 30 odd cells then populate them in 12 cells. I just want the ek13 value or name to populate this cell if the value in table ey13;ge26 is true in rows 15 to 26. Ive even tried to populate top to bottom on table then try a lookup function but the window type can constantly change then ill have blank cells on screenshot 1 table. Otherwise i can try multiple nested if eqautions yet if i have a true v alue then it will also reflect in next cell.

    Please assist
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by eb85; 06-03-2024 at 08:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 10-13-2023, 07:32 AM
  2. Replies: 6
    Last Post: 02-24-2019, 09:02 PM
  3. Separate data by sequential order and find missing count
    By Kiran1811 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2018, 09:13 AM
  4. [SOLVED] Use 2 separate rows to populate data in a separate table....
    By Sbenn316 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2017, 11:38 AM
  5. [SOLVED] Find order and populate userform with the data from a sheet
    By intex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2016, 04:36 PM
  6. Find unique order and populate userform
    By intex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2016, 03:18 PM
  7. [SOLVED] find first cell value on separate page and insert value once
    By rs1aj in forum Excel General
    Replies: 3
    Last Post: 05-22-2015, 05:48 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