+ Reply to Thread
Results 1 to 3 of 3

can you reference a cell in all sheets without typing EACH tab's name?

  1. #1
    Forum Contributor
    Join Date
    11-11-2004
    MS-Off Ver
    pro + 2019
    Posts
    134

    can you reference a cell in all sheets without typing EACH tab's name?

    good morning Gurus:



    I've got some duplicate tabs--one for each person in a group.

    I'd like to grab some totals that each tab has--again, all duplicately laid out.

    Is there a syntax using "SHEET" that can grab (for example) G2 from every sheet so I can manipulate it?

  2. #2
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    Germany
    MS-Off Ver
    365
    Posts
    472

    Re: can you reference a cell in all sheets without typing EACH tab's name?

    Use the INDIRECT-function.

  3. #3
    Forum Contributor
    Join Date
    11-11-2004
    MS-Off Ver
    pro + 2019
    Posts
    134

    Re: can you reference a cell in all sheets without typing EACH tab's name?

    Hi there,

    Yeah, that's where I'm headed. Seems like I can make a table somewhere of the sheets' names and just use indirect and some lookups to do the math. that way as I add sheets it's just a quick entry there.

    Seems promising so far....?

+ 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. [SOLVED] trying to save time with quoting a cell reference rather than typing it in formula
    By rayted in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-05-2020, 07:33 AM
  2. [SOLVED] VBA reference a range of cells in WB array instead of manually typing names out
    By Hoover5896 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-27-2017, 11:13 AM
  3. Replies: 5
    Last Post: 04-08-2017, 11:48 AM
  4. [SOLVED] Validating two sheets and typing text into a column for the results
    By Andreas_Zopo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-03-2017, 09:42 PM
  5. [SOLVED] Reference cell across sheets with no value
    By BeckyW19 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2016, 11:16 AM
  6. [SOLVED] sum of cell reference in all sheets
    By wacky_diva in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2013, 12:08 AM
  7. Replies: 5
    Last Post: 03-12-2013, 08:23 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