Results 1 to 3 of 3
  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Sorts and Filters (Excel '07)

    I have a spreadsheet that contains name, address, phone numbers etc. This is a list that a classmate sent to me to help locate people for our upcoming class reunion (NO I wont say how long! <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> suffice to say though that computers in that era were in big cold rooms.
    Anyway the workbook came with just one sheet. I took it and added a concatenated column for first and last names, then added 3 more sheets titled By City, State, Deceased, and Discriminatory. The first two sheets I added are sorted, the third is filtered (hence the name discriminatory). All work just fine. What I want to do however is link the data on the sheets together, so that if you change the data on ANY sheet it will update the others. I know that I can paste link from one sheet to the others, but what about linking from any of the workbooks? for example entering in data in the City, State and have it go to al of the other workbooks as well?
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorts and Filters (Excel '07)

    I don't understand why you would want all those sheets. You can sort and filter on the main sheet all you want.

    And where do other workbooks come into this? You only said you added three sheets. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Sorts and Filters (Excel '07)

    You're correct, in that I don't need all of those extra sheets. I have the sheets sorted so that I can pull up the pre-sorted ones that I want to make changes on, w/o having to re-sort or filter the original.
    There is no other workbook, that was a typo.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

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