View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Clavien Michael Clavien is offline
external usenet poster
 
Posts: 1
Default Formula for labels!

Hi All
I need to label a small warehouse .

I think Excel could generate labels describing location of various shelves
in such a row and such a bay, but I am not sure how

I need to label such as a prefix plus an aisle a bay a row and then a box
on a shelf . The numbers are not critical

What I was thinking of as an example is DX-Aisle-Bay01-Row1-BoxA

There are about 9 aisle,6 bay per aisle, 6 row per bay and 3 box per row so
it would be quite a job to do manually.

Anyone can help
Thanks
Michael