print based on condition

Hello, I am trying to come up with a way so that a manager can print a report showing which employees fall under which manager and their salaries. So in the file I have Managers 1,2,3, & 4 and various employees. All the managers are in column A, employees Column B. So I guess this is similar...

Hello All, Please find attached an example of the problem I currently have. I have a continuous master sheet 1 containing records of daily incoming parts. I would like to write a macro that auto fills all rows of the Print sheet with the corresponding rows of the Master sheet based on the Date...

Hi, I'm having difficulties with building an printing option for specific goods selected on the list. I have a form witch contains an subform. On the main form user is able to select supplier and based on the supplier can choose article that he's interested in. On the subform user get the list...

Title says it all really. I have a workbook that upon opening I want to refresh, run a macro, then print. I'm pretty sure I can do all that but I want to limit the time so that unless someone happens to open it at 6:58 am it won't automatically print. Thanks

I like the code that is shown in the below thread that allows me to create a separate sheet and put a "0" or "1" to select which sheets I need to print. But I also need to have these sheets print with sheet no.s filled out in the footer. The first sheet selected is Sheet 1 of X (X=the total no...

Hi, I'm new to VBA and most of what I have learned has been through Google and I have found a lot on this site. I am trying to write a code that will prevent the user from printing the worksheet if two specific cells are blank. I have tried the following codes, none of which have worked. The...

Hello all. I read an earlier post regarding this issue, however, the fixes provided in that post did not work for me. I have a spreadsheet form that I need to show color formatting when it's on the computer, but I need it to print without the color in certain cells. I only have a black and white...

Hello MrExcel, i am trying to get excel to print a selected cell after the "enter" event of another cell. <colgroup><col><col><col><col></colgroup><tbody> Item Count Scanned SKU's Item # Bin Location 1 010838120078 ALE12007 b8-15-04-08 2 047497330005 AML3300001 g9-04-02-04 3 047497330012...

I developed a spreadsheet to score golf tournaments, do skins, various flights, etc. to help the Men's Club. It has been fun but an Excel expert, I'm not. If I could solve the problem below without using a macro that would be preferred. Once upon a time I was a programmer, but that's moons...

Hi, I need to print the following areas that are on the worksheet "Zipcode Summary". Each area A1:U62, A63:U125, ect. should print on its own page if the range does not equal #N/A. I tried modifying the VBA I found, but do not know enough to get it to work. Sub Print_Zips() ' Page 1 If...