Good morning.
I am trying to find a way to solve a problem. I have constructed a workbook which will:
- be used by multiple people (each using their own version) each day
- the data for the different days will be recorded on different sheets in the same book named after the date eg ddmmyy
- the users will record different pieces of information in 15 minute increments on the sheet between 08:00 and 18:45
- this info will be captured in columns C, D and E
For example, 08:00 column C might be completed "project", column D "prep work", column E "initial scope".
08:15 "personal development", "reading", "excel"
The entries into C and D are validation bound however E is free text and doesn't matter as much.
At the end of each day I need the information captured to be collated into a master spreadsheet for that day where the data can be analysed and maniuplated. Around ~80 people will be completing these data capture workbooks so, in the interests of time saving, I would like to find a way to automate the export of the data.
I am not overly familiar with visual basic, other than the very basics, however I think that there would be a way to:
- add a button onto the sheet which says "submit"
- clicking this would run a macro
- the macro would export the users data to a specific range of cells in a sheet corresponding to the date in the master workbook
- so, I would end up with a collation of the data for that 1 day in columns C, D and E for all the books.
- There would be different collation sheets for the different days.
The different workbooks will be in the same folder on the same shared drive.
I appreciate any guidance I can be given in this specific matter. I am keen to learn more about macros etc so if anybody has a link to a useful guide or suggested literature I would also be thankful for that. I may not need a macro and may be overcomplicating things.
Thanks and kind regards.
I am trying to find a way to solve a problem. I have constructed a workbook which will:
- be used by multiple people (each using their own version) each day
- the data for the different days will be recorded on different sheets in the same book named after the date eg ddmmyy
- the users will record different pieces of information in 15 minute increments on the sheet between 08:00 and 18:45
- this info will be captured in columns C, D and E
For example, 08:00 column C might be completed "project", column D "prep work", column E "initial scope".
08:15 "personal development", "reading", "excel"
The entries into C and D are validation bound however E is free text and doesn't matter as much.
At the end of each day I need the information captured to be collated into a master spreadsheet for that day where the data can be analysed and maniuplated. Around ~80 people will be completing these data capture workbooks so, in the interests of time saving, I would like to find a way to automate the export of the data.
I am not overly familiar with visual basic, other than the very basics, however I think that there would be a way to:
- add a button onto the sheet which says "submit"
- clicking this would run a macro
- the macro would export the users data to a specific range of cells in a sheet corresponding to the date in the master workbook
- so, I would end up with a collation of the data for that 1 day in columns C, D and E for all the books.
- There would be different collation sheets for the different days.
The different workbooks will be in the same folder on the same shared drive.
I appreciate any guidance I can be given in this specific matter. I am keen to learn more about macros etc so if anybody has a link to a useful guide or suggested literature I would also be thankful for that. I may not need a macro and may be overcomplicating things.
Thanks and kind regards.
