Copy formulas from cells in one row

[khalil]

hi all

i want to make formulas in number of cells to jump automatically to the next cells in the next row once i use any formula in the first row.

thanks inadvance

 

[GlennUK]

Your description is not very clear, so I'll you want to know how to make cell references in formulas adjust as you copy ... make the cell references relative, i.e. remove the $ from the cell reference, so C2 instead of $C$2.

There are three absolute styles:

Reference Style and Meaning:
$A$1 = Both the column and row reference are fixed. Neither will be incremented or changed during a copy or fill operation.

$A1 = Only the column reference is fixed. This will not change during a fill or copy, but the row will change.

A$1 = Only the row reference is fixed. This will not change during a fill or copy, but the column will change.

If you select a reference in the formula, you can press F4 to cycle the reference between the 4 styles, e.g. C2 $C2 C$2 $C$2.

 

[khalil]

hi Glenn

For example

Cell A1 has a formula
Cell A2 is blank

what i want is when cell A1 is filled with number or text through the formula in it then A2 will has the same formula from A1 automatically .

this is inorder not to copy 100's of rows down with the formula, to reduce the amount of saved cells

thanks Glenn