Wanting to print specific worksheet based on current week

[TheTubaGeek]

I have a project I have been working on for a little while and I'm now to the point where I need some macros and/or buttons to round out functionality. The end game for this project is to turn it into a template that will be distributed to all employees.

Over the past few weeks, I have been working on a consolidated time sheet for the company I work for. The purpose is two-fold: not only do employees have all of their time sheets for the year in one place, but also they are able to quickly view how much time off they have available.

So far, I have been able to get the Time Off/Vacation Tracker worksheet setup and working smoothly. Now, I'm at the point where I am cleaning up/tweaking the time sheet functionality and will have to design some macros and/or buttons to achieve the desired results.

Right now, I am looking for a button that, when clicked from the first worksheet the workbook (called "Vacation Tracker"), the time sheet (worksheet) for the current week is sent to the printer. Right now, I have 1 worksheet per week of the year with each one designated as "Week <number>".

I had in mind to make it where the entered data on the time sheets clears out at a certain point, but then I realized that the vacation time remaining calculation is built off those time sheets. That makes the situation a little bit more convoluted, especially when you consider that vacation time does not reset on the same day for everyone. I talked to a co-worker about it and he suggested a setup page where (on 01/01?) you would input your hire date and vacation left to date so it would track what you have left until your anniversary date. Then, I guess when the new year starts, the remaining vacation time would be moved to a new field so that can continue to be tracked until your next anniversary date.

The people on here have been an amazing help so far, and I greatly appreciate any further assistance you can offer!

[mikeTRON]

Post a sample workbook and specifically indicate what you are trying to accomplish and we can probably help.

When you say print the week number, I have no way of knowing if you mean literally print it via a printer or post a formula in a cell or post a value in a cell.

[TheTubaGeek]

File attached.

Print Macro Help.xlsx

[TheTubaGeek]

Bump. Still requiring assistance.

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, Macro Needed and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[TheTubaGeek]

Title has been modified

[TheTubaGeek]

OK, I tweaked the title a little more after realizing I still wasn't being very clear.