Numbring unsorted summaries

[snd]

I get these catering summaries monthly, but each month the summaries' sheets are scrambled:
Column B:
Accounting Dept.
HR
Legal
Engineering
Sub Contractors
Guests
Operations
Maint.
Clinic
Admin.
Supply Chain
Etc.
Column C:
Figures (total number) of meals provided.
I do the job as the following:
In Column A is the heading Serial#, Col. "B" Cost Center, Col. "C", Total No. of meals.
For example, this month, I received the summaries in a box file: "Legal" summary was on top, "Accounting" beneth it, etc.
I'd scroll down to Legal Dept, and number it 1, move right twice, and key in its total number of meals. Then I"ll scroll up to "Accounting", and number it 2, etc. Then at the end, I sort the table ascending for Col. "A", to organize the summaries as received.
My question:
Is there a way for srl.#s in Col. "A" to be numbered automatically. Say, for "Legal Dept.", I'd just enter its total no. in Col. "C", and srl# "1" will show in Col. "A", then "Accounting Dept." will show "2" after I enter its total no. Then, I'll just copy-value the formulae in Col. "A", and sort.
I'd really appreciate your help, as I sometimes forget to enter the srl#.
Thank you in advance.
Sanad (snd).

 

[jasonb75]

Create a list of dept names and serial numbers elsewhere then use vlookup to fill column A.

 

[snd]

Create a list of dept names and serial numbers elsewhere then use vlookup to fill column A.

Thank you jasonb75 for the reply.
I see what you mean. But, those summaries I talked about are only for one site. Our company has four sites. (4 box files + 1 box for back charging some sub contractors personnel who are not covered), each has its own operating departments, (except for Accts, HR, obviously). i.e., each site has its own facilities (depts.): Eng., Production, Operation, Exploration, Clinic, Admin., W'hse,Training, Maintenance, Cars Shop,...
Is it possible to do the srl# of summaries automatically?
If not, I'll just do it as you cordially suggested.
Thanks again.

 

[jasonb75]

Based on the information that you have provided I see no reason why it shouldn't still work.

A formula is automatic once you have filled the table.