+ Reply to Thread
Results 1 to 3 of 3

Dynamic List from other Sheets - Auto adjustment if row/column inserted in others sheets

Hybrid View

QuentinLDN Dynamic List from other... 09-16-2020, 04:58 AM
AlphaFrog Re: Dynamic List from other... 09-17-2020, 05:00 AM
bebo021999 Re: Dynamic List from other... 09-17-2020, 05:17 AM
  1. #1
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,645

    Re: Dynamic List from other Sheets - Auto adjustment if row/column inserted in others shee

    To refer to cell in row 3 column B of a dynamic sheet name in B2, why not? (No helper, ofcourse):

    =INDIRECT("'"&$B$2&"'!$B"&ROW(3:3))

    To avoid "Zero" from blank cell, try:

    =IF(INDIRECT("'"&$B$2&"'!$B"&ROW(3:3))=0,"",INDIRECT("'"&$B$2&"'!$B"&ROW(3:3)))
    Drag down as far as probably need.
    Attached Files Attached Files
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create a dynamic list from multiple sheets
    By shbiskup in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-28-2022, 04:04 AM
  2. [SOLVED] Generate dynamic list of Sheets
    By llamafarmer in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-21-2019, 08:55 AM
  3. Compare Sheets and Display the previous sheets column in current sheets
    By maddyrafi1987 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-09-2017, 04:03 AM
  4. [SOLVED] Select all sheets from a dynamic list
    By rousseauassociates in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-23-2016, 05:14 AM
  5. [SOLVED] Create a Dynamic Master List from 10 different sheets.
    By djshane in forum Excel General
    Replies: 3
    Last Post: 06-12-2016, 05:06 AM
  6. Replies: 7
    Last Post: 07-29-2014, 11:10 AM
  7. Replies: 1
    Last Post: 02-25-2013, 11:37 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