Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatically Dup cell info (2000)

    I am trying to figure out how to do the following:

    I have a spreadsheet with multiple tabs.
    The first tab contains 3000 rows of information. Each of these rows has a 3-letter identifier/category (there are 25 categories). This identifier is used to categorize all of the information (ADJ, BLJ, COD

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Automatically Dup cell info (2000)

    judy1,

    You might be happier with the layout and your ability to access the individual categories by taking another approach.
    You can enter new information at the bottom of the "work" sheet and then sort the entire set of data by column A.
    That will put all like categories together.

    And/or... use Data | Filter | AutoFilter to show the individual categories and you don't have to transfer the data to 25 additional worksheets.

    For what it's worth - a workbook can have multiple tabs (sheets), a spreadsheet has only one tab.

    Regards,
    Jim Cone
    San Francisco, CA

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Automatically Dup cell info (2000)

    I agree with Jim, I would not separate and try to keep them all updated. Keep it in 1 table. You can use autofilter/advanced filter and include subtotals to get info and also summarize easily using a pivot table.

    This will be much more difficult if separate sheets are used

    Steve

  4. #4
    New Lounger
    Join Date
    Aug 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically Dup cell info (2000)

    Thank you both for your help!

    It worked like a charm!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •