Insertion of a cell address that constantly rises by a set number

Posted to microsoft.public.excel.misc

SteW

external usenet poster

Posts: 293

Insertion of a cell address that constantly rises by a set number

I have a large spread sheet I am working on and I wish to increase a cell
address by 103 every time
ie
=L103,= L206,=L309 ETC

Is there a formula that will increase this address

thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do i remove a constantly appearing % in a cell in excel?	Bertram	Excel Discussion (Misc queries)	1	May 26th 08 03:22 PM
Auto column insertion based on a number	halatree	Excel Worksheet Functions	0	January 11th 08 08:47 PM
Auto row insertion based on a number	Eugene Wong	Excel Worksheet Functions	6	September 28th 07 06:28 AM
automatic multiple insertion of 0 infront of a tel number?	Collet Makgojane	Excel Discussion (Misc queries)	2	January 31st 07 08:04 AM
VB Random Number Generation/Insertion/NextWorksheet	Craig	Excel Discussion (Misc queries)	4	February 27th 05 10:00 PM

All times are GMT +1. The time now is 04:13 PM.

Menu

About Us