Copy several formulas to the right and only changing the column letter

[tiggi]

Hello,

Please refer to the attached, sheet "Summary".

There are formulas within cells C4 to C118 (C58 and C111 is collapsed), how would I copy these formulas to columns D through to J and the only thing I need to change are the column letters within the formulas?

For example, cell C4 contains the formula =SUM(Database!H4:H1116) under team member AZ and I'll need this formula to be entered in as =SUM(Database!AJ4:AJ1116) for team member AK.

The cell numbers won't change. It's very time consuming doing these manually and when I copy and paste, excel automatically changes the cell numbers too.

Please help urgently. Thank you in advance!

[icestationzbra]

use this formula in cell C4 of Summary tab:

Please Login or Register  to view this content.

when you drag-fill this formula towards right onto cell D4, the formula will automatically update to:

Please Login or Register  to view this content.

does that help?