Results 1 to 7 of 7

How to make sheet name as dynamic in formula?

Threaded View

  1. 06-23-2021, 10:12 AM #1
    Indra Rai
    Indra Rai is offline
    Forum Contributor
    Join Date
    09-14-2011
    Location
    Nepal
    MS-Off Ver
    Office 2021
    Posts
    117

    Thumbs up How to make sheet name as dynamic in formula?

    Hi there,

    I have a hundreds of sheet name: 1,2,3,4,5...so on. I have to copy from all sheets into combine sheet. How to make sheet name dynamic in formula for drag down? Your suggestion is highly appreciated. Sample file is attached.

    Regards,
    Indra
    Attached Files Attached Files
    Last edited by Indra Rai; 06-23-2021 at 10:24 AM.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Make a dynamic 'sheet' active to be able to extract data into an array.
    By Scoobster_doo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2017, 01:13 PM
  2. Make a dynamic 'sheet' active to be able to extract data into an array.
    By Scoobster_doo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2017, 08:40 AM
  3. [SOLVED] help to make formula dynamic
    By Lewster in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 05-12-2016, 04:39 PM
  4. [SOLVED] Make YTD formula dynamic.
    By ammartino44 in forum Excel General
    Replies: 4
    Last Post: 03-25-2015, 01:07 AM
  5. How to make a dynamic range with multiple tables on sheet?
    By AlexRM in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2015, 08:32 PM
  6. [SOLVED] Suggestion on how to make Sheet name is more dynamic
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2013, 12:37 PM
  7. Daily trades sheet..How to make dynamic.
    By Gogan in forum Excel General
    Replies: 1
    Last Post: 03-01-2007, 03:27 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