Try the Offset function.
-b

"0-0 Wai Wai ^-^" wrote:

>
> Hi.
> I have forumlas which reference to a lot of cells, eg:
> =...A1, ...A1, ... A1+A$2-$A3...
> ....B1, ...B1, ...B1+B$2-$B3...
> .... ...
> .... ...
>
> Is it possible to do something like:
> =...A1, ...Same as left, ... Same as left + (SameButRowDown1) +
> (SameButRowDown2)
> ....SamebutColRight1, ... Same as left + (SameButRowDown1) + (SameButRowDown2)
> .... ...
> .... ...
>
> "Same as left" means the referencing is the same as the left cell reference. so
> for "=...$C$5, ...Same as left", it's equal to "=...$C$5, ...$C$5"
> "RowDown1" means switching the row down by 1, eg from A1 to A2.
> "ColRight1" means switching the column to the right by 1, eg from A1 to B1.
>
> Any workaround is acceptable. You may not need to do exactly the same.
> Thanks a lot!
>
>
>
> --
> Additional info about my computer:
> - Office XP
> - Windows XP Pro
>
>
>