Microsoft Office Forums Looking for help with creating sequential serial number on one page

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2019, 12:55 PM
4ener 4ener is offline Looking for help with creating sequential serial number on one page Windows 10 Looking for help with creating sequential serial number on one page Office 2019
Novice
Looking for help with creating sequential serial number on one page
 
Join Date: Feb 2019
Location: Calabogie, Ontario Canada
Posts: 5
4ener is on a distinguished road
Default Looking for help with creating sequential serial number on one page

I build guitars for as a hobby and want to keep track of who has what by using serial numbers printed on water slide paper and then affixed to the back of the headstock. I've attached a word document with what I have in mind and was wondering whether someone has either something already or can tell how to go about doing it.



I've found a few types already but unfortunately, couldn't get them to work at all.

I have no experience in using macros and the like and have no idea about where to start. I've attached what I have in mind... SMG Serial Number Sheet.docx

Any suggestions would be appreciated.
Reply With Quote
  #2  
Old 02-21-2019, 02:17 PM
macropod's Avatar
macropod macropod is offline Looking for help with creating sequential serial number on one page Windows 7 64bit Looking for help with creating sequential serial number on one page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,575
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The simplest approach would be to use an Excel worksheet formatted with the desired layout. See the attached workbook, which is already formatted for 3 pages of labels.

Note the formula used in A1. Once you've used up the existing 3 pages of labels, you can either:
use Find/Replace to change the 1500 to 1680 for all cells, or
copy the existing columns and paste them to the right the current ones.
Either approach will give you a new set of labels to work with.
Attached Files
File Type: xlsx SMG Serial #s.xlsx (10.5 KB, 3 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-22-2019, 08:43 AM
kilroy kilroy is offline Looking for help with creating sequential serial number on one page Windows 10 Looking for help with creating sequential serial number on one page Office 2016
Competent Performer
 
Join Date: Sep 2016
Location: Southern Ontario
Posts: 109
kilroy is on a distinguished road
Default

Copy of SMG Serial #s.xlsx


4Ener Macrpods excel sheet is great. I've added some of the stuff I track/would track when I finally start back working on guitars again. I'm currently setting up to make up Stave style drums.

Waterslides can be submitted to Bedlam in any format.

https://www.bedlamcreations.com/requ...e-decal-quote/
Reply With Quote
  #4  
Old 02-22-2019, 01:31 PM
4ener 4ener is offline Looking for help with creating sequential serial number on one page Windows 10 Looking for help with creating sequential serial number on one page Office 2019
Novice
Looking for help with creating sequential serial number on one page
 
Join Date: Feb 2019
Location: Calabogie, Ontario Canada
Posts: 5
4ener is on a distinguished road
Default

Thanks to both of you for your input it's going to save me a fair bit or work.....
Reply With Quote
  #5  
Old 02-23-2019, 07:33 AM
4ener 4ener is offline Looking for help with creating sequential serial number on one page Windows 10 Looking for help with creating sequential serial number on one page Office 2019
Novice
Looking for help with creating sequential serial number on one page
 
Join Date: Feb 2019
Location: Calabogie, Ontario Canada
Posts: 5
4ener is on a distinguished road
Default

OK, folks

I do have one problem... I want to get the spreadsheet to a point where I can copy and paste to Word and print a single sheet of 8 1/2 x 11 waterslide paper in order to get about 45 numbers on the sheet.

When I try to copy and paste the 45 cells, it gives one page and 15th line on a second page. I've tried rescaling the print etc... but don't know what I'm doing with Excel anymore, I've used it in over 20 years and am growing frustrated..... I've likely lost a few brain cells over that time which could be the issue.

As before, any help would be appreciated and I've attached the excel files which I'm using now.......
Attached Files
File Type: xlsx CGW Serial #s.xlsx (11.1 KB, 1 views)
Reply With Quote
  #6  
Old 02-23-2019, 09:13 AM
kilroy kilroy is offline Looking for help with creating sequential serial number on one page Windows 10 Looking for help with creating sequential serial number on one page Office 2016
Competent Performer
 
Join Date: Sep 2016
Location: Southern Ontario
Posts: 109
kilroy is on a distinguished road
Default

Serial numbers in word.docx


sometimes you need to adjust the margins and play with the font size.
Reply With Quote
  #7  
Old 02-23-2019, 01:44 PM
macropod's Avatar
macropod macropod is offline Looking for help with creating sequential serial number on one page Windows 7 64bit Looking for help with creating sequential serial number on one page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,575
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by 4ener View Post
I do have one problem... I want to get the spreadsheet to a point where I can copy and paste to Word and print a single sheet of 8 1/2 x 11 waterslide paper in order to get about 45 numbers on the sheet.
Instead of trying to copy and paste to Word, adjust the Excel cell dimensions and margins to suit.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #8  
Old 02-24-2019, 05:16 AM
4ener 4ener is offline Looking for help with creating sequential serial number on one page Windows 10 Looking for help with creating sequential serial number on one page Office 2019
Novice
Looking for help with creating sequential serial number on one page
 
Join Date: Feb 2019
Location: Calabogie, Ontario Canada
Posts: 5
4ener is on a distinguished road
Default

Think I tried that, but it didn't work. It could also be that I don't know what I am doing with Excel, it doesn't look like the same product I was using 20 some years ago. If you could help me out here, that would be great...
Reply With Quote
  #9  
Old 02-24-2019, 05:35 AM
macropod's Avatar
macropod macropod is offline Looking for help with creating sequential serial number on one page Windows 7 64bit Looking for help with creating sequential serial number on one page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,575
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You're going to have to provide rather more detail than "it didn't work".
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #10  
Old 02-24-2019, 07:50 AM
4ener 4ener is offline Looking for help with creating sequential serial number on one page Windows 10 Looking for help with creating sequential serial number on one page Office 2019
Novice
Looking for help with creating sequential serial number on one page
 
Join Date: Feb 2019
Location: Calabogie, Ontario Canada
Posts: 5
4ener is on a distinguished road
Default

Sorry about that, I got something working now. It's not quite what I wanted, but it will certainly do for now.

Thanks again.....
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for help with creating sequential serial number on one page Sequential Numbering A Document When The Same Number Appears Twice on a Page Auxiliaryman COB Word 3 08-02-2017 03:10 PM
Looking for help with creating sequential serial number on one page Creating alphanumeric incremental serial numbers srinivasaru Excel Programming 8 04-03-2017 12:53 PM
Add a serial number to an invoice pringle747 Excel Programming 6 02-19-2015 11:19 AM
Looking for help with creating sequential serial number on one page Creating a TOC with sequential letters instead of page numbers at the right margin shansen Word 1 03-11-2014 12:43 PM
Looking for help with creating sequential serial number on one page Serial Number Issue rehan5001 Excel 1 06-08-2011 02:46 AM


All times are GMT -7. The time now is 04:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft