Results 1 to 2 of 2

Autofill problem or is it not autofill?

Threaded View

  1. #1
    Registered User
    Join Date
    02-14-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Autofill problem or is it not autofill?

    Hi All, I'm new on here and very new to using Excel 2003 so please be gentle!!!
    I'm a District Nurse and have been trying to make a worksheet with my weekly visits on but am struggling.
    I have a worksheet with column A having names, B addresses and C through to I with days of the week. If I see a patient on any given day I place an x in the column relevant to that day. This gives me a view of my weeks patient caseload.I call this my master sheet. I also wanted to filter out those patients I see on specific days of the week so I have copied the master sheet and created 7 more sheets that I access from the bottom row where it says sheet 1, 2 etc. I've surprisingly named these mon through to sunday! I then auto filtered out the non blank days in each of these days giving me exactly what I wanted. However, and here is my problem: when I add or delete a patient on the master sheet it doesn't update any of the mon, through to sunday sheets. Is there any way I can do this? Any help would be heartfeltly appreciated. My knowledge of Excel is very very basic but I am learning, albeit slowly.

    Thanks,

    Pat
    Last edited by Pat Feasey; 02-15-2011 at 03:30 PM. Reason: asked to by moderator.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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