+ Reply to Thread
Results 1 to 4 of 4

Linking multiple sheets

  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    Nepal
    MS-Off Ver
    Excel 2010
    Posts
    8

    Question Linking multiple sheets

    I have a workbook that contains more than 67 sheets of same formats and columns. Now, in a new sheet in the same workbook, I want to count the cells of Column B of all sheets separately, for example:
    Column B of Nepal - 456 Cells
    Column B of Pak - 1245 Cells
    Column B of CHN - 981 Cells
    Column B of UK - 1027 Cells
    Column B of USA - 789 Cells
    & so on

    I would like to have a common formula to link the all sheets instead of clicking each sheet one by one using =CountA(Nepal!B:B) and so on. I tried it listing all sheet names in a new sheet and applying formula to its corresponding cell. It took long time and tedious job to click again and again. So please suggest me a formula so that I can do it in easy way.
    Attached Files Attached Files
    Last edited by Ratna K. Sthapit; 06-16-2020 at 12:56 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Linking multiple sheets

    Why not all date in the same worksheet / in 1 worksheet?

    That will make it a lot easier to analyse the data.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    09-26-2019
    Location
    Phoenix, AZ
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2303 Build 16.0.16227.20202) 64-bit
    Posts
    78

    Re: Linking multiple sheets

    How about doing a sumproduct indirect with named ranges?
    "Stairs, they are always up to something."

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Linking multiple sheets

    Please paste the following into cell C5 and then drag the fill handle down: =COUNTA(INDIRECT(B5&"!$B$5:$B$500"))
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Text Linking Multiple Sheets
    By james52637 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2012, 03:38 PM
  2. Excel 2007 : Linking multiple cells between sheets
    By CommonGRND in forum Excel General
    Replies: 1
    Last Post: 11-02-2010, 07:35 PM
  3. Linking multiple sheets to ONE?
    By alex.muntz in forum Excel General
    Replies: 1
    Last Post: 06-08-2010, 03:33 AM
  4. Linking data to multiple sheets
    By dklatt in forum Excel General
    Replies: 2
    Last Post: 04-24-2010, 12:25 PM
  5. Linking sheets multiple calculations
    By captain chaos in forum Excel General
    Replies: 2
    Last Post: 10-30-2009, 09:53 AM
  6. Conditional linking between multiple sheets
    By Lexi Techy in forum Excel General
    Replies: 20
    Last Post: 11-25-2008, 08:18 AM
  7. linking data from multiple sheets
    By sjhonny in forum Excel General
    Replies: 3
    Last Post: 01-08-2007, 01:10 PM
  8. Linking multiple sheets
    By JMR in forum Excel General
    Replies: 3
    Last Post: 08-30-2005, 08:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1