1. A

    Help required creating multiple page invoice template

    Good evening, I am trying to create an invoice template in excel that will, if necessary, use more than one page. On each page I require all headings and titles to be the same, including footers, with only the product listing changing. I am using IF and VLOOKUP to pull the 'Invoice To' and...
  2. J

    Copy active worksheets

    Hi I have a workbook that I use for inventory tracking. I make a copy of the last worksheet almost every day and name it todays date. After some time the workbook becomes very large and slow to work with. I am therefore trying to create a macro that will move all previous months sheets to a new...

    Multi Sheet Printing.

    Hey All you excel gods out there... here is my Macro for printing 4 Different sheets at once. Sub PRINTALL() Sheets(Array("Index", "Main", "Addendum Page", "Notes Pages")).Select Application.ActivePrinter = "CutePDF Writer on CPW2:" ExecuteExcel4Macro _...
  4. M

    Sort data on sheet2 to data on sheet1

    ****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...
  5. T

    HELP! Sums from different Sheets!

    I am trying to create a spreadsheet for monthly expenses where the fixed expenses are on sheet 1 and the actual table is on sheet 2... Fixed expenses in sheet 2 are denoted by =Sheet1!$B$3 ect, referring to sheet 1. I then tried to sum up all of the months expenses I get the correct answer on...
  6. L

    Writing multi-worksheet PDFs

    I have a need to concatentate several worksheet pages to wite a single PDF. I have been successfully doing this (using CutePDF as writer) for a long time. Today, it is trying to write the pages one at a time. I had to merge some pages in manually from another worksheet into this file, which is...

Some videos you may like

This Week's Hot Topics