imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
Printing question, I have a work book with multiple sheets working on Gratuity
Input sheet1
Button1 Button2 button3 ……so on
Sheet1
Sheet2
Sheet3
Sheet4…………Sheet12
The input sheet is obviously where the person inputs the information.
What my question is I need a method of printing the other sheets through a button or something else.
When button1 is pressed it prints out sheet1 and 4 but not 3
Button 2 sheet3 and 6 but not 1
That I can do by recording macro, but here is where I get totally lost.
If on the input sheet if a person has worked more then (calculated in cell A1(start date)-A2(end date)=total years) 5 years it prints out sheet 1 one and 2. But a person who has worked 10 years it sheets it prints out sheet 1,2,5 and 6 when button 1 is pushed and so on.
I am really new to excel so I am hoping I have asked this question in the right way so it is understandable. Any help would be greatly appreciated. If you are able to assist please make it as simple as possible.
Input sheet1
Button1 Button2 button3 ……so on
Sheet1
Sheet2
Sheet3
Sheet4…………Sheet12
The input sheet is obviously where the person inputs the information.
What my question is I need a method of printing the other sheets through a button or something else.
When button1 is pressed it prints out sheet1 and 4 but not 3
Button 2 sheet3 and 6 but not 1
That I can do by recording macro, but here is where I get totally lost.
If on the input sheet if a person has worked more then (calculated in cell A1(start date)-A2(end date)=total years) 5 years it prints out sheet 1 one and 2. But a person who has worked 10 years it sheets it prints out sheet 1,2,5 and 6 when button 1 is pushed and so on.
I am really new to excel so I am hoping I have asked this question in the right way so it is understandable. Any help would be greatly appreciated. If you are able to assist please make it as simple as possible.