If this is a duplicate, I apologize. I waited two hours and couldn't find my post.
I have a spreadsheet, the username is on the far left. After that, several fields I don't care about and then fields labeled 1 - 31 where I input hours spent on each user on that day. I use comments to track what I have done for each user.
My expertise level. I'm a moderate Excel user but I have no experience with VB. If given cut and paste code, I don't know how to put it into the spreadsheet.
What I need:
I want 1 row per page of report. I want the username, the month that is the tab name *or* I can add a field to my spreadsheet. Then I need to have the numeric entry in each field 1-31 and comments on each cell, the comments needs to be either beside or under the entry for that day.
An approximation would be:
Username
1 2.75 comment: 1:30 - 4:15 accompanied to appointment
2 .5 comment: 2:00 - 2:30 consulted with staff
All through the month.
Can anyone help me to figure out how to do this?
Thanks so much!!!
I have a spreadsheet, the username is on the far left. After that, several fields I don't care about and then fields labeled 1 - 31 where I input hours spent on each user on that day. I use comments to track what I have done for each user.
My expertise level. I'm a moderate Excel user but I have no experience with VB. If given cut and paste code, I don't know how to put it into the spreadsheet.
What I need:
I want 1 row per page of report. I want the username, the month that is the tab name *or* I can add a field to my spreadsheet. Then I need to have the numeric entry in each field 1-31 and comments on each cell, the comments needs to be either beside or under the entry for that day.
An approximation would be:
Username
1 2.75 comment: 1:30 - 4:15 accompanied to appointment
2 .5 comment: 2:00 - 2:30 consulted with staff
All through the month.
Can anyone help me to figure out how to do this?
Thanks so much!!!