Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QuickFill Exhibit Numbers and/or letters

Status
Not open for further replies.

lilbpaw

Technical User
Jul 21, 2002
18
US
Came across and issue with QuickFill that I can not seem to get around.
Usually you make a table and input your numbers say for example... 1.. 2.. 3.. then quick fill them and it will finish them off in sequence.
However, I am finding that with the Alphabet it just wants to repeat the things I have already typed.. so lets say I put A in the first box, b in the second c in the third then did a quick fill it will put a... b... c... a... a.. b.. c.. and so forth.
Most importantly I am really needing to quick fill label sheets... with Exhibit Numbers... So for example I put in the first box MCA-002, then the next box would be MCA-002 then third would be MCA-003... well i need about 1,000 exhibit stickers... so I would like to be able to possibly QuickFill 80 or so at a time, but when I try i get a page full of the same Exhibit numbers over and over.

Any suggestions?

Lilbpaw
 
Sorry, was in a hurry, I need to quickfill numbers such as MCA-001 through MCA-080 or so at a time. no repeat numbers.
These are four exhibits for court so .. any how...

Lilbpaw
 
You get what you get with QuickFill.

Lotus123 does Fill by example which works the way you want. Excel works a little better than Qpro and WordPerfect. It handles the abc-001, abc-002 but not a,b,c.

In Qpro, you could add a custom Fill to solve the problem if you did this a lot. In wp, you only solution would be a custom macro.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top