Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Oct 2004
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto copying between worksheets (2000)

    I have a user who wants to be able to have text added to one worksheet, appear on another worksheet, based on information in one field. Example -- the main sheet would hold all information. Each record would be have a column that would contain, north, south, east or west. She would like to have all the "East" information automatically copy to a separate worksheet in the same workbook that would contain only "East" info. Another option would be to enter the information on the separate sheet and have it appear on the mastersheet? Is this possible? There are no caculations, just text that will be updated often. Thanks for any suggestions.

  2. #2
    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: Auto copying between worksheets (2000)

    I am not keen on keeping 2 copies of identical data. Keeping both sets updated is a pain. What about just haveing a master list and then using AUTOFILTER to work with the data. An item (EWNS column) could be filtered on and the filtered data printed, viewed, whatever. You could even include SUBTOTALs to get "stats" of the visible data.

    Also you could get summaries easily just using a pivot table.

    Steve

  3. #3
    Star Lounger
    Join Date
    Oct 2004
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto copying between worksheets (2000)

    I'm with you on the not keeping 2 copies of data. I suggested using the filters, but she didn't like that option. I don't know how to use pivot tables. Can you recomend a good resource for learning how they work? Thanks for your prompt response.

  4. #4
    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: Auto copying between worksheets (2000)

    Here are some links from Jon Peltier sites on Pivot tables.

    Steve

  5. #5
    Star Lounger
    Join Date
    Oct 2004
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto copying between worksheets (2000)

    Thanks--I'll check it out.

Posting Permissions

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