Autofill for cells in a certain pattern

[etizzle]

Dear Mr-Excel Community

I have been using excel for a while but i can hardly call myself a pro,

Anyways i would like to autofill a few cells which are in a pattern based on data in differant cells,
here is an example of the code that i am using

for cell g5 i entered =c0
for cell g6 i entered =c33
for cell g7 i entered =c65

The data that needs to go into the g column is in increments of 32
i was wondering if there was an easier way to do this using a formula/autofill as excel wont recognize this pattern,

Thanks in advance,
Ethan


I have to do this hundreds of times,

 

[AliGW]

The problem is that you have asked for one thing, but presented another. The reason that it won't work is that the number of rows between each of the department numbers is different - it is not always 32. Sorry - I have run out of time for this now. Hopefully someone else will step in.

 

[etizzle]

The problem is that you have asked for one thing, but presented another. The reason that it won't work is that the number of rows between each of the department numbers is different - it is not always 32. Sorry - I have run out of time for this now. Hopefully someone else will step in.

Thankyou soo much Ali,you are a genius, you have solved my problem.
i appreciate all your valuable time and with you all the best for the future

 

[AliGW]

No, I'm no genius, but I do have a logical mind and I can count!!! I'm glad it helped.