If you do not wish to copy A1, (the entered numeric value) but you wish to copy the FORMULA that you put in A2, then do this: select A2, then place your cursor in the bottom right corner of that cell. You will notice that the cursor changes to a small black cross (unlike the white embossed cross) This is the autofill feature.
You can go to the right and it will fill in the consecutive cells with the corresponding increasing values BUT, if you want it to increase, you must have a range of numbers for it to base it's increase on.
For example: I put 34 in A1, then 38 in A2, I select A1 and A2 tegether, go the bottom right hand corner, and press and hold the mouse and drag right. The numbers are increased as I move right by a value determined by the difference between A1 and A2 (or increases by four) So A3 would be 42, A4 would be 46 and so on.
Now, then if you want to just USE the value of A2, then you might want to consider the "PASTE SPECIAL" feature. This allows you to use the value of the cell selected anywhere in the workbook. If the value of the selected cell changes, the "PASTE SPECIAL" will carry that value to the new location you selected.
For Example: Using your example, A1 has the numeric value of "34. A2 is set to reflect the value of A1, I would copy A2, then go to where you want the value put (say B5) and do the "PASTE SPECIAL". The corresponding value of Whatever was in A2 will be reflected in B5. And it will automatically update everytime the value of A2 changes.
What this prevents is the cells adjusting when you do a simple copy.
I hope this is what you were refering to.
If you need more help, I will try whatever I can.