fill down formulas without selecting the sheet  
Author Message
BevDaily





PostPosted: Thu Aug 04 06:26:09 CDT 2005 Top

SQL Server Developer >> fill down formulas without selecting the sheet

At the moment I have a bunch of formulas along the top row of a sheet and I
wish to copy them down a predfined number of rows. At the moment I activate
the sheet and then select the rows I want to copy down with the row
containing the formulas at the top. It would be much cooler if I could
accomplish this in the background as it were without having to select the
sheet. Is there a way of effectively filling down the formula without having
to activate the sheet?

Any help much appreciated, kind regards, Mark

SQL Server142  
 
 
Jens





PostPosted: Thu Aug 04 06:26:09 CDT 2005 Top

SQL Server Developer >> fill down formulas without selecting the sheet Are you sure you posted in the right NG ? That should go for the excel ng as
I hear from your problem ?!
--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---




> At the moment I have a bunch of formulas along the top row of a sheet and I
> wish to copy them down a predfined number of rows. At the moment I activate
> the sheet and then select the rows I want to copy down with the row
> containing the formulas at the top. It would be much cooler if I could
> accomplish this in the background as it were without having to select the
> sheet. Is there a way of effectively filling down the formula without having
> to activate the sheet?
>
> Any help much appreciated, kind regards, Mark
>
>
>