ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   GENERATE ROUTE No's AUTOMATICALLY (https://www.excelbanter.com/excel-programming/409204-generate-route-nos-automatically.html)

11

GENERATE ROUTE No's AUTOMATICALLY
 
I'm preparing some route charts to give the transport guys to pick up
my team mat's

When prepared far a week the route no's will go up to 140..(like wt-01
to wt-140)

on every route there will be 2-6 rows, the Colum where I put route
number fill be same but the rows may defer for each route

IS THERE ANY WAY TO GENERATE ROUTE No's AUTOMATICALLY ON THE COLUM
WHERE WE DO MENTION THE ROUTE NUMBER ON ??

I know it's confusing but can any one help me on this...?!!

Steve[_110_]

GENERATE ROUTE No's AUTOMATICALLY
 
This could be easily be built in a an Access database. If you would like to
build a database to do what you describe, contact me.

Steve



"11" wrote in message
...
I'm preparing some route charts to give the transport guys to pick up
my team mat's

When prepared far a week the route no's will go up to 140..(like wt-01
to wt-140)

on every route there will be 2-6 rows, the Colum where I put route
number fill be same but the rows may defer for each route

IS THERE ANY WAY TO GENERATE ROUTE No's AUTOMATICALLY ON THE COLUM
WHERE WE DO MENTION THE ROUTE NUMBER ON ??

I know it's confusing but can any one help me on this...?!!




11

GENERATE ROUTE No's AUTOMATICALLY
 
hi steve,

I don't have a clue on Access till now..

If there is no other option inside excel then i have to start learning
ACCESS from U.. :)




Steve[_110_]

GENERATE ROUTE No's AUTOMATICALLY
 
Access is the right tool for this problem. It's up to you.

Steve




"11" wrote in message
...
hi steve,

I don't have a clue on Access till now..

If there is no other option inside excel then i have to start learning
ACCESS from U.. :)







All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com