1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Filling a pre printed form in Excel

Discussion in 'Business Applications' started by jb623, Jun 28, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. jb623

    jb623 Thread Starter

    Joined:
    Jun 28, 2012
    Messages:
    3
    I've spent the last four hours trying to solve this/use info that's similar to my problem to no avail. I feel I'm so close I can smell the answer is near! :)

    I have a form I use for work that I manually have to fill in 50 times a day with mostly the same information. This is definitely a job for a computer!

    Ideally, I would like to open the spreadsheet and have a button that says 'Print' and it will print what I need - 50 forms with the right information.

    So far I have done the following:

    Created a custom page size (16cm x 14.7cm)
    Scanned an original to use as a background so I can line up the information
    Adjusted the Excel boxes to print the info in the right place.

    Now I need to print the following number ranges as identifiers:

    1 - 22, 29-42 and 51-54

    I feel I'm close with using this macro:

    Private Sub Workbook_BeforePrint(Cancel As Boolean)
    [copy] = [copy] + 1
    End Sub

    I use both Excel 2003 and 2007, depending on where I am!

    I have NO experience of macros until today, so any advice is very welcome.

    Regardsm

    Jeff.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1058941