+ Reply to Thread
Results 1 to 4 of 4

Extracting data based on a cells value or advance filter?

  1. #1
    Registered User
    Join Date
    03-14-2011
    Location
    UK
    MS-Off Ver
    2007,2010 but decided to start my learning from Excel 2003
    Posts
    4

    Extracting data based on a cells value or advance filter?

    Hi All,
    This is my first ever experience in a forum. Having read the rules, I ask for advance apology if I am posting in a wrong place.
    I feel to explain a bit how we work so it helps to understand my requirement. I have also attached a sample workbook.
    I work in a company where team leaders plan the quarterly site visits. There are mainly three types of visits as shown in the workbook. Field staff get to see the plan for each month and update their work on it as and when they can during a month. All the staff have their own machines/laptops with unique login IDs on our intranet and each machine has a unique asset no.
    Team leaders plan the quarterly visits as in sheet ‘Planning’ under three main types. I want this sheet to generate 12 sheets (or 3 for each quarter), one for each month with details of only planned sites. I have shown only 25 sites here whereas the actual numbers are much more, so the need for omitting non-planned sites is quite important.
    Now the field staff update these monthly sheets (like the one att, i.e ‘Apr’). I have included a column for names for staff to input their names against each completed visit. I think the login IDs or machine no could help in omitting this column and excel should automatically include the person’s name based on their ID/Machine no. But, if this is not possible-its not a problem.
    I want the monthly sheets to update already existing sheet – ‘Work record’ based on the details updated by the field staff for only completed visits.
    Last sheet, ‘To be carried forward’ needs to catch all the visits marked as ‘ carried forward’ by staff in the monthly sheets (‘Apr’ in this case) and add this to next quarter’s plan in ‘Planning’.
    If you think the layout of the sheets needs a bit of modification, please do so, as long as it contains the basic info as I have included.
    Finally my sincere thanks to all those who will help me out of this problem.
    Ciao
    Attached Files Attached Files
    Last edited by Geniusduffer; 03-15-2011 at 01:17 PM.

  2. #2
    Registered User
    Join Date
    03-14-2011
    Location
    UK
    MS-Off Ver
    2007,2010 but decided to start my learning from Excel 2003
    Posts
    4

    Re: Extracting data based on a cells value or advance filter?

    There has been a change in the plan, so I will post a new workbook as template...
    Nobody has died of hardwork, but why to take risks

  3. #3
    Registered User
    Join Date
    03-14-2011
    Location
    UK
    MS-Off Ver
    2007,2010 but decided to start my learning from Excel 2003
    Posts
    4

    Re: Extracting data based on a cells value or advance filter?

    After having a discussion with colleagues here, the changes to my last post are:
    Team leaders plan the visits in terms of numbers of visits to a specific site on Planning sheet. Now this sheet needs to generate 12 sheets for the year or 3 for a quarter, distributing the number and types of visit as equal as possible within a quarter.
    I have tried to link the sheets to carry forward the incomplete work from one month to other within monthly sheets, please dont mind my useless formulae, I am just learning.
    If the monthly sheets take care of overflowing work then we decided that there would be no need for a separate sheet for carried forward work.
    The sheet recording the work needs to record the work based on dates, and preferably grouped in months.

  4. #4
    Registered User
    Join Date
    03-14-2011
    Location
    UK
    MS-Off Ver
    2007,2010 but decided to start my learning from Excel 2003
    Posts
    4

    Re: Extracting data based on a cells value or advance filter?

    I have now uploaded the newer version of workbook

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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