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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
No luck...WebSense blocks it. :groan:

Smitty
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
No real sure of another way to let you see what i have?
These are the only 2 methods I know?
Michael
 

thazan

Board Regular
Joined
May 14, 2007
Messages
57
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.
 

Forum statistics

Threads
1,181,053
Messages
5,927,848
Members
436,572
Latest member
khalid hussain

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
Top