+ Reply to Thread
Results 1 to 3 of 3

Seperate Excel Spread sheet from Region column

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Seperate Excel Spread sheet from Region column

    I attached here 1overall data, here i want to spread sheets separately by region wise, i have attached sample output in 2nd sheet and 3rd sheet, like wise i want seperate excel sheet from the attached excel.
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Seperate Excel Spread sheet from Region column

    Try

    A2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Paste the same formula in other sheets as well
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Seperate Excel Spread sheet from Region column

    See attached file, where I have set this up for you.

    All you need to do is to copy one of the existing sheets (e.g. Baksa) by CTRL-dragging the tab, then rename the new sheet to whichever region you like.

    It might be better to just have one sheet and to have a drop-down in cell W1 where you can select the region of interest.

    Hope this helps.

    Pete
    Attached Files Attached Files

+ 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. Row to column on a seperate sheet
    By dead* in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-08-2015, 02:05 PM
  2. sorting a spread sheet by column
    By J Glanton in forum Excel General
    Replies: 2
    Last Post: 07-10-2015, 04:15 PM
  3. Replies: 0
    Last Post: 01-19-2015, 03:31 PM
  4. Replies: 3
    Last Post: 04-19-2014, 06:10 PM
  5. Replies: 10
    Last Post: 12-20-2013, 09:03 PM
  6. Replies: 1
    Last Post: 10-04-2007, 12:04 PM
  7. [SOLVED] Master spread sheet to manage then show info on seperate tabs
    By Little pete in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2006, 10:30 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