I am wondering if it is possible to create word documents from data within excel.
Essentially, I work with spreadsheets which track people's sign in and sign out times. I start off by sorting them per person and then copy and paste the data for one person at a time in to a word document to send to the correct manager. As you can imagine, it is a very lengthy and manual process. It looks like it might be possible to automate this process by running a macro, is this the case? If so, do you have any advice on how to get this set up? This is my first time looking at VBA and I would be very grateful for any support.
Example of Raw Data:
Name Time In Time Out John Doe 06/04/2023 09:10 06/04/2023 10:54 Jane Doe 06/04/2023 07:54 06/04/2023 12:31 Adam Person 06/04/2023 08:15 06/04/2023 13:27 John Doe 07/04/2023 07:49 07/04/2023 12:02 Jane Doe 07/04/2023 08:17 07/04/2023 11:54 Adam Person 07/04/2023 11:15 07/04/2023 15:33 John Doe 08/04/2023 08:01 08/04/2023 12:36 Jane Doe 08/04/2023 11:19 08/04/2023 17:22 Adam Person 08/04/2023 07:56 08/04/2023 12:03
Example of Completed Data:
Name Time In Time Out John Doe 06/04/2023 09:10 06/04/2023 10:54 John Doe 07/04/2023 07:49 07/04/2023 12:02 John Doe 08/04/2023 08:01 08/04/2023 12:36 Jane Doe 06/04/2023 07:54 06/04/2023 12:31 Jane Doe 07/04/2023 08:17 07/04/2023 11:54 Jane Doe 08/04/2023 11:19 08/04/2023 17:22 Adam Person 06/04/2023 08:15 06/04/2023 13:27 Adam Person 07/04/2023 11:15 07/04/2023 15:33 Adam Person 08/04/2023 07:56 08/04/2023 12:03
Bookmarks