Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-06-2010, 10:18 AM
Kimberly Kimberly is offline Invoice Number Generation Windows 7 Invoice Number Generation Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

You could use a formula if you want. If you use this one, change the J10 to be the first StaffMember cell. Don't change the A1 references, they're there to produce a 1 but produce a 2 when copied (and then a 3, etc.) Copy down. The value will automatically generate as soon as data is entered into the StaffMember cell for that row.

=IF(LEN(J10)=0,"","PK"&REPT(0,4-LEN(ROW(A1)))&ROW(A1))

You can copy and paste values periodically if desired.

Another method: you could easily make a formula that would increment the value by 1 each row, and be formatted to display with PK and zeroes in front, but that would be displayed, not stored.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to reduce top margin in even and odd pages in pdf generation using msword Nandu4u Word 0 11-20-2009 07:16 AM
MSOA Express 2009: Export or Print custom modified Invoice Template derelyth Misc 0 10-19-2009 03:33 PM
Invoice Number Generation Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM
Templates: automatic text generation from Rich Text content control Chickenmunga Word 0 10-01-2008 11:16 AM
Invoice Number Generation change currency $ to £ on excel invoice help deanorx7 Excel 3 07-08-2008 04:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:22 AM.


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