copy down without changing cell numbers to bottom of worksheet

's Computer Specifications

Hi, looking for help, I have a formula e.g. (='Staff Fund Totals'!B24-B4) ia
top cell, i need this copied down to the bottom of the worksheet only
changing the last dell number in the formula e.g (='Staff Fund
Totals'!B24-B5) and so on.

Thanks

Mark

's Computer Specifications

='Staff Fund Totals'!B$24-B4

Regards,
Stefi

â€žsantavigaâ€ ezt Ã*rta:

> Hi, looking for help, I have a formula e.g. (='Staff Fund Totals'!B24-B4) ia
> top cell, i need this copied down to the bottom of the worksheet only
> changing the last dell number in the formula e.g (='Staff Fund
> Totals'!B24-B5) and so on.
>
> Thanks
>
> Mark

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options	Yuvraj	Microsoft Excel Misc	0	29th Jun 2009 11:20 AM
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing	Yuvraj	Microsoft Excel Misc	0	26th Jun 2009 06:01 PM
Changing figures bottom axis text from numbers to time	libertyforall	Microsoft Excel Discussion	2	27th Apr 2009 11:41 AM
Look at numbers between 2 numbers and copy the complete rows to a worksheet.	bartman1980	Microsoft Excel Programming	2	15th Aug 2007 02:56 PM
Way To Copy Formula In Column Without Changing All Cell Numbers	travelersway	Microsoft Excel Misc	2	3rd Sep 2005 08:36 PM