+ Reply to Thread
Results 1 to 6 of 6

Selecting Cells based on Row value and short new sheet based on Cell value

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    Eindhoven, Netherland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Selecting Cells based on Row value and short new sheet based on Cell value

    Hello

    I am new to this forum but i need help already

    I have a big excel file with schedule for drivers. car fleet nr, and days

    In one row there are weeknr , row below the date , row blow dat the daynames.

    than Collum A is driver

    Now i have filled the rest with the carfleet nr or AG

    Driver have 3 options
    -Saturday / Sunday they change

    1 - They stay driving (same car on Saturday and Sunday)

    2 - They Start driving (Saturday AG, and Sunday Carnr)

    3 - Thy Stop driving ( Saturday has Carnr , and Sunday AG)

    example of 1 week

    Driver 1 Car1 Car1 Car1 Car1 Car1 Car1 Car1 AAG
    Driver 2 AG AG AG AG AG AG AG Car 1
    Driver 3 Car2 Car2 Car2 Car2 Car2 Car2 Car2 Car2

    on a other sheet user enters a weeknr , and button , than it generates a list below this button on that sheet a list that selects and short driver based on the end (Saturday / Sunday ) of that week


    STAY STOP START FREE SICK

    DRIVER3 DRIVER1 DRIVER2


    Of course i have more than 3 drivers , an i have 5 states

    STAY , STOP, START, FREE, SICK

    everytime a user change weeknr this list so renew

    this very hard one i know, i tryed alot of option ith lookup / index / match etc

    any help is welcome with this challenging task

    Greets John
    Attached Files Attached Files
    Last edited by John1969; 05-10-2016 at 11:36 AM.

  2. #2
    Forum Contributor kalbasiatka's Avatar
    Join Date
    02-27-2016
    Location
    Brest, Belarus
    MS-Off Ver
    2021
    Posts
    224

    Re: advanced VBA

    Hi. Show your file can be trimmed, if it is big. Or just make an example with a real data structure.
    To do it for me and help me it is 2 different things!
    Sorry for my english, blame Google translator

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: advanced VBA

    Hi John,

    Please change the title of the thread to something more descriptive... imagine a google search... "advanced VBA" does not give any indication of what the subject really is.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: advanced VBA

    Welcome to the Forum John1969!! As a new member, please take the time to review our rules. There aren't many, and they are all important. Rule 1 of our Forum RULES is Your post title should accurately and concisely describe your problem.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  5. #5
    Registered User
    Join Date
    05-10-2016
    Location
    Eindhoven, Netherland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: advanced VBA

    Added the file, this only a example

  6. #6
    Registered User
    Join Date
    05-10-2016
    Location
    Eindhoven, Netherland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: advanced VBA

    i changed the title

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. More advanced advanced filtering
    By Acceleracer in forum Excel General
    Replies: 2
    Last Post: 02-06-2014, 09:02 PM
  2. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  3. Advanced Right
    By roly in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-10-2007, 07:25 AM
  4. Advanced IF-THEN... Help Please
    By Apoction in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2006, 02:37 PM
  5. Replies: 2
    Last Post: 07-21-2006, 10:05 AM
  6. advanced if?????
    By taran in forum Excel Formulas & Functions
    Replies: 50
    Last Post: 09-06-2005, 07:05 PM
  7. Advanced use of IF
    By Backdoor Cover in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 03:05 AM
  8. [SOLVED] advanced filter a range:Advanced Filter function
    By Il Principe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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