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:
 
Alright, I'm at home and naturally I can see it now. ;)

If you name your ranges, you can record a macro selecting them and printing the selections.

I'd post a sample for you, but I'm in the process of installing Office 2007 here.

Smitty
 
Upvote 0

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,216,025
Messages
6,128,348
Members
449,443
Latest member
Chrissy_M

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