Hi long time reader, first time poster! I hope that my post title was acceptable.
I have a staff scheduling workbook that my team members use to create weekly employee schedules. They would like to enter the shift info into a table laid out in the manner it will be printed and posted. The attached example #1 in the file will illustrate.
I need to have the schedule info the team member enters be copied onto a different worksheet in the workbook in a conventional list format so that I can build a pivot table from it. I am very comfortable with the pivot table use once I get the data into the correct form, see example #2 in the file.
Your help is greatly appreciated as I know the correct solution is to bag the whole mess and learn access, but our busy season is kicking in and I won't have time until june! I consider myself very comforatble with excel in general but have never ventured into VBA. I am ready to cautiously go into that good night if needed (with guidance)!
Thanks Again, your time is very appreciated!