+ Reply to Thread
Results 1 to 7 of 7

Split exel - document for planning

  1. #1
    Registered User
    Join Date
    10-07-2019
    Location
    belgium
    MS-Off Ver
    365
    Posts
    3

    Split exel - document for planning

    Hello

    I have an excel document with 50 names of employees (1 name = 1 row) and with 365 columns (1 column = 1 day, tells which workshift to do).
    We would like to send each employee his annual planning without everyone to see the planning of his colleagues + the possibility to give remarks about which work shifts they want to change (f.e. 'date x/week x I want a late shift, not an early one, ..')

    Worst case scenario is to use the 'mail merge' from Word en create 50 seperate documents that we can e-mail to the employees (= their personal annual planning), but that seems a lots of work …

    Does anyone have an idea which software program we could use? I was thinking about Office Forms and Google Forms but the options are rather limited (you can't select a date f.e.)

    Is there a possibility to split the excel automatically per row and create separate documents automatically? So we can e-mail the planning to each employee? Still a lot of work though...


    I hope my question isn't too vague English is nog my mother language but I did my best

    Thank you.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Split exel - document for planning

    Hi, do you have dummy-data sample file?
    Maybe that will make it easier to help you with.
    What is BEVBR for Office version
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    10-07-2019
    Location
    belgium
    MS-Off Ver
    365
    Posts
    3

    Re: Split exel - document for planning

    I don't seem to succeed in adding an attachment in this thread, no idea what I'm doing wrong
    Plan B was a print screen :-)

    print screen.jpg

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Split exel - document for planning

    Klik op advanced and manage attachments a print screen won’t do
    Try again please

  5. #5
    Registered User
    Join Date
    10-07-2019
    Location
    belgium
    MS-Off Ver
    365
    Posts
    3

    Re: Split exel - document for planning

    should be added now ..
    Attached Files Attached Files

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Split exel - document for planning

    Okay, will take a look and see if I understand what you want and if I can help

  7. #7
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Split exel - document for planning

    /Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    https://www.pc-helpforum.be/topic/73...nningsdocument

    I've done it for you this time but be aware that it isn't appreciated by the helpers on this and other fora.

    I wanted to post this on the other forum but they have closed your thread there so I will do it here.

    Try this with only a few employees because files are created and sent automatically.

    Put a valid emailaddress in Column B of sheet Email for the first 3 employees before running the code.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Extract exel cell values into a word document
    By Theofan21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2016, 09:22 AM
  2. How to Split Ver Large Exel File Into Smaller Files of 1000 Rows in Size
    By rusmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2013, 02:11 PM
  3. Replies: 2
    Last Post: 04-23-2013, 08:59 AM

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