Help with Absolute and relative

[temp codata]

I'm working on an excel spreadsheet that calculates overtime from different departments in my company.

I have it working but need help with the copy cell function.

Example of my problem -
In my cell I have ="Department"!A1
In the next column cell I have ="Department"!B1

This is pulling the data from the worksheet "Department" and the corresponding cell
The row number one needs to always stay the same and the letter referencing the column needs to change with each cell
When I copy, it keeps the column letter and changes the row number (1,2,3,ect).
So I try and put a $ in front of the 1 to keep it an absolute ="Department"!A$1
But then when I copy the cell it copies the exact formula. It's supposed to change the column letter to the next letter in the alphabet.
I have to believe there is a way to do this, but I've spent hours searching the net with no luck.

Can anyone give me the correct formula?

Thank you.

[oeldere]

Yes we can, but maybe you better add your workbook, without confidentional information.

Or

="Department"!A$1

If you drag the valua to the right, your formula will work.

It will change in ="Department"!B$1 => c => d etc.

[Kevin UK]

just goggled this site, might give you a few idea's about cell referencing.

http://www.awardsites.com/tutorials/...ell_ref-01.htm