Auto populating cell references in function

[c3rberu5]

Hello All,

Is there any way to auto fill the cell reference within a function?

I have a spreadsheet where functions are linked to each other and a function needs to be pasted into different places within a sheet, over 200 instances.

Example.

=A1+A2

Is there a character I could place instead of A2 which will change to the cell reference where the function is pasted to?

Thanks

 

[c3rberu5]

I cant attach the file on this forum yet but here is a summary.

I can only change functions not the document contents. I had to minimise the keystrokes and amount of navigation needed to fill in the tables.

1. The original document given has a series of rows with quesions with a ABC box selection

	E	D	C	B	A
Question	X

<tbody>
</tbody>

2. when a selection is made a summary is filled below with a countif function.

E	D	C	B	A
2	1	1	1	0
0	25	50	75	100
0	25	50	75	0
30	% Achievement

<tbody>
</tbody>

I have added a table which uses data validation drop boxes with A-E list selection, which in turn add the X in point 1 using =IF($E$124="E","X","")

1.1	E
1.2	B
1.3	C
1.4	D
1.5	E

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

Filling each and every one of these boxes with the =IF is time consuming is there another way to do this only using functions or a shortcut as there are 40 questions and 5 selections for each you can imagine how long this would take.

Any ideas on a easier way?