Pasting formulas

[WNYP8]

Hello,

I have a list of numbers and a grid made up of 20 cells for each box. I need to fill in 1 cell in the grid with a number in the list.

I have a basic function such as "=A2", and I want to just copy and paste the function in the next order "=A3,=A4,=A5,=A,6...", but in different cells.

I'm trying to copy the =A2 function from C2 to D2, but it's changed to =B2. Is there anyway to make it =A3 instead?

Thank you!

 

[Pouky]

Hi WNYP8,

Could you maybe post an example of what your sheet looks like?

I know you can keep the A as an A by putting an '$' in front of it like so:

=$A2