+ Reply to Thread
Results 1 to 8 of 8

Shift handover book [Nederlands]

  1. #1
    Registered User
    Join Date
    12-14-2019
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    7

    Shift handover book [Nederlands]

    Hello

    I'm busy to make a logbook system for handover between our team.
    I have a designed sheet to fill with content or select from dropdowns.
    The range of the sheet i want to save to another sheet and then clear.
    Also if somebody push the save button again it's have to overwrite when it's the same day and hours are between 5 and 10 (example)

    Example. working hours shift one are 7 am to 9 am. when you click save it have so save or overwrite
    When i click save en it's 9.01 am it have to save to new empty cells in the save sheet.
    Difficult to explain when english is not my basic language.
    I hope somebody understand

    i atached the file

    Thx in advance
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    185

    Re: Shift handover book

    Hi,

    Can you explain how you want it to be saved?

    Save it to the save location sheet like in a database form?
    Copy the whole sheet? and save with a date Sheetname?

    The SAVE LOCATION sheet has not all data fields that are on the log sheet so you need to tell us how you see it or make an example in the worksheet with data so we can deduct what you mean

    Als Nederlands makkelijker is kan dat natuurlijk ook.
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Registered User
    Join Date
    12-14-2019
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    7

    Re: Shift handover book

    Nederlands zal inderdaad gemakkelijker zijn in dit geval.
    Je hebt waarschijnlijk de eerste sheet (LOG) gezien.
    Dit wil ik volledig opslaan in de sheet ernaast (SAVE LOCATION). Beetje als database inderdaad of misschien de range van A1 tot P33 met alle huidige formats. Heb nog geen idee wat het makkelijkste zou zijn.
    Nu per dag hebben we dus 3 shiften.
    TIjdens de shift per dag zal er vanalles ingevuld worden en af en toe gesaved worden.
    Het overzichtelijkste lijkt me dat als de shift bezig is de informatie word opgeslaan telkens op dezelfde plek in de sheet ernaast.
    Pas als er een nieuwe shift begonnen is, moet deze opslaan op de volgende lege regels of range.
    Hopelijk versta je dit beter?

    De button dat er nu staat op de eerste sheet, is momenteel enkel clear van de cells, maar omdat ik met merged cells zit is de code nog niet af.
    Die oplossing heb ik zelfs nog niet gevonden.

    Groeten

  4. #4
    Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    185

    Re: Shift handover book

    De groene balk heeft 4 cellen moet dit zo of eigenlijk maar 1

  5. #5
    Registered User
    Join Date
    12-14-2019
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    7

    Re: Shift handover book

    De groene balk is voorzien met 4 dropdowns om leden die aanwezig zijn aan te duiden.

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    16,170

    Re: Shift handover book [Nederlands]

    Moved from VBA forum because the entire discussion is now in Dutch.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  7. #7
    Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    185

    Re: Shift handover book [Nederlands]

    Hallo,

    Ik denk dat dit beantwoord aan je verwachtingen

    Laat maar weten als er nog wat niet goed is


    Grtz
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    12-14-2019
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    7

    Re: Shift handover book [Nederlands]

    Ik bekijk het vanavond eens op mijn gemak. Thx

+ 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. Replies: 0
    Last Post: 06-18-2015, 12:47 PM
  2. ProjectZichtbaar maken (Nederlands)
    By blake20 in forum Non English Excel
    Replies: 0
    Last Post: 03-26-2014, 04:13 AM
  3. Probleem [NEDERLANDS]
    By Extreming in forum Non English Excel
    Replies: 4
    Last Post: 03-11-2014, 02:23 AM
  4. Code Fout [NEDERLANDS]
    By Extreming in forum Non English Excel
    Replies: 2
    Last Post: 03-07-2014, 01:30 PM
  5. Replies: 4
    Last Post: 06-28-2012, 02:41 PM
  6. De Regels van het forum in het Nederlands
    By Simon Lloyd in forum Forums Rules
    Replies: 0
    Last Post: 06-24-2008, 12:25 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