Excel autofill and formula function

[ronlau123]

Hi, everyone

I have a stupid task assign by my supervisor. I face the problem to doing it. I will keep case briefly

my company has a lot of filing cabinet. (more than 150). Some cabinets are for filing legal documents, some for accounting. Some cabinet for accounting. My boss want me to record what strata numbe's document inside cabinet


I have a excel and word (for printing labels and then put on cabinet). On label, it shows strata number, size, number of drawer....
I have excel to input all information. However, starting cabinet no. 42, I need to record each drawer of cabinet. I just want to know is it any way to use custom auto fill list to create strata cabinet number:


Cabinet no. 42 has 3 drawer, I need to have 3 entries: Cabinet No. 42 drawer 1, Cabinet No. 42 drawer 2, cabinet no.42 drawer 3. then next record is cabinet no. 43 drawer 1....i do not want to input cabinet number one by one..

thanks everyone.

[TMS]

Oh, good grief ...

[ronlau123]

TM shucks... thanks very much.
However, I must use the format of Excel that I upload
we use label, avery 6449. Each cabinet only can use half of label. (therefore, you see Column A and H instead of column A only)

[ronlau123]

HI, brother

May I ask can anyone help me? I should make the sample more easy to understand?