Print just certain peoples time

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
Below is a picture of a weekly timesheet for 3 employees:
:confused: :confused:
TimesheetSample.jpg


Is there a way to just print specific blocks of names in the list? :rolleyes:

Do I need to highlight then some how print? pick from a list? The names are not always going to be the same or in the same order, so wha twould be the easiest way to pick the 7 rows that go with the name and have them print? In the sample given, I may want to print the first and third person listed, then print the 2nd and 4th person listed.

Let me know if I am not clear on this and I will try to explain further.

Thank you,
Michael :wink:
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
No real sure of another way to let you see what i have?
These are the only 2 methods I know?
Michael
 
Upvote 0
You can probably do this in a macro. But, if you just want an easy work-around you can always just highlight the areas you want to print. You highlight one name and then hold Ctrl and highlight the second area. then go to File -> Print Area -> Set Print Area. This will let you print only the areas you have selected.

I hope this helps.
 
Upvote 0

Forum statistics

Threads
1,214,391
Messages
6,119,249
Members
448,879
Latest member
oksanana

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top