Closed Thread
Results 1 to 2 of 2

Same page printed but with changing sequential number on it

  1. #1
    Registered User
    Join Date
    01-24-2008
    Posts
    18

    Question Same page printed but with changing sequential number on it

    ok, I've reposted this from the general forum http://www.excelforum.com/excel-gene...ber-on-it.html
    as seems more suited over here!

    I have a selected area which I print as labels.
    I want to have a number on this label counting back from a number entered in a cell.
    So if 300 is entered in cell N12 label shows somewhere 300, the 2nd label 299, the third 298 and so on.

    Also ideally the number will be joined to cell K23 which is already subject to some formatting.

    I would then hit macro for printing and select desired quantityto print.

    I have stripped down my file for you to look at,

    Many thanks for looking.
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Stick to the original, ask a moderator to move it.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1