printed

Hi All, this question I asked a long time ago and didn't really get on top of it, I'm assuming I would need some VBA code to accomplish this Looking for some help on this one, if I have a series of numbers in cells A1:A20, then I would like these numbers to be printed in there corresponding...

Hi, I would like to print a table - 50 times - from excel, but on each printed sheet I would like the number 1, 2 ... 50 to appear. The table is in the range A1:G20. On the first printed sheet appear the number 1 (in D22) on the second sheet appear 2 and so on.

Hello guys, I used code already existed and changed it for my needs but I have troubles with adding function for counting how many labels per each row will be printed with zebra printer. Here below is picture of table (Table6) which I am using as data. Label is on different sheet: VBA Code...

Hi, I want a my first row of a long document be repeated not only in the top of each printed page but also in the middle, is it possible ?

Hi all I'm still having difficulty finding out how (if) I can have the contents of one particular cell, ie C3 on each sheet, printed in a Header, alongside the Sheet Name. I would like to be able to type in the year the spreadsheet applies to, ie 2019 for this year, and then when the worksheet...

I have a range of cells that need to be printed and different ranges are to be printed depending on a filter that has been applied. I have had to set up some manual page breaks to make sure the pages are printed correctly, but the problem I have is when the filters are on there are some blank...

I have a macro that cycles thru Excel sheets and performs a print. Some sheets need only certain areas printed, and some sheets do NOT NEED PRINTED AT ALL. The first portion of this is easy enough to handle by using the "Print_Area" name set to the areas to be printed, however, I cannot figure...

We at work have quite unique problem. We have 12 word docs out of which few ( basis requirements)need to be printed for every job. Can anyone help to create excel sheet / or guide so that those word documents can be printed from excel itself and each having unique sequential number and date...

Dear All I am using the following code to print my Invoices Dim n As Long n = Application.InputBox("Number of extra printed copies.?", "Printed Copies", 1, Type:=1) If n <= 0 Then Exit Sub ' User canceled With ActiveSheet.PageSetup .RightHeader = "(ORIGINAL FOR RECIPIENT) "...

Hello Friends, I need help to Extract DATA from one workbook to another.... Here is the DATA Sample <tbody> REF P.O # P.O.DATE Customer Factory Article Quality Dyed or Printed Fiber Content Construction Size Quantity UNIT 132 78118 19-Dec-13 ABC GA Bed Sets CVC Renforce - 90 Gsm Pigment...

Hello! I need serious help creating a formula that: 1. Calculates the time between two dates - submitted and printed I.e Submitted date 03-Jan-2017 16:33:46 Printed date 04-Jan-2017 12:39:48 2. And secondly shows as passed if lower than 24 hrs, or failed if greater than 24hrs. Thanks...

Is there an easy way to prevent a chart being split over two pages when printed? I have a chart at the end of a large amount of data which will resize depending on the data available. When the report is printed I don't want the chart to be split, I'd rather it was just on the next page in one...

When you copy there is an option to copy as a picture. When choosing tat option it asks you if you would liek to copy as shown when printed. However when I choose this option it does not show me sheet as shown when printed. I have slicers that are not suppose to show when printed yet they do. Am...

I have a project where I need a cell to auto increment by one every 4th printed page. It would look like this. Page 1 - Pallet 1 of 100 Page 2 - Pallet 1 of 100 Page 3 - Pallet 1 of 100 Page 4 - Pallet 1 of 100 Page 5 - Pallet 2 of 100 etc... What would I need to do to accomplish this? Thanks

Hi, Is there any way I can highlight (fill color) cells with color, but then when I print/export to pdf, those cells will be printed as non-fill cell (just like normal)? It's like "insert comments" but not printing those comments in printout. Thanks.

Hello all I have a file with about 100 different sheets. I need to be able to print individual pdf's of each sheet automatically. I currently use the following Dim ws As Worksheet For Each ws In Worksheets ws.Select nm = ws.Name ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _...

We are familiar with repeating columns on the left feature However, the state is requiring that in these workbooks we are printing that the last four columns be printed on every page exactly as they appear For example columns a,b,c,d,e,f,g,h,i last 4 columns w,x,y,z The last 4 columns...

Hi, Is it possible to check whether or not an excel workbook was printed? There is a "last printed date" section on the file menu drop down, however, that field will automatically populate with a date/time once the print menu is pressed (e.g. clicking print and then closing it without printing)...

So here is what I am trying to do. I have a spread with several sheets that are printed on a periodic basis. What I want is when a sheet is printed is for today's date to be added to a "Print Log" tab as a record of when it was done. Thanks,

Good day. I am using Excel 2013 on Windows 10. After creating several Macros in one Workbook, I find that the macros are spread over different modules. Is there a way to move all of the macros into one module so that the script of the macros can be printed out? Thank you for any help. Dan...