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
|