LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
tb
 
Posts: n/a
Default Insert rows, keep a formula?

I currently have a formula in my worksheet to refer to names to wages on
another worksheet, this is fine and works well. But when I insert more rows
(not the last row before the sum) the formula doesn't continue? I have to
ctrl c, ctrl v to keep the formula going in added rows.

Is there a way I can keep the formula going as I insert more rows without
copying everytime?

Thanks
tb
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
can't insert more rows even though not at max rows nikkiamber Excel Worksheet Functions 3 April 4th 05 10:45 PM
Formula to compare multiple rows values based on another column? Murph Excel Worksheet Functions 4 February 21st 05 02:44 AM
if formula = negative #, then insert a word Nicole L. Excel Worksheet Functions 10 February 4th 05 10:34 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
How get the rows indicated by one formula to become the input for. katgolightly Excel Worksheet Functions 5 December 29th 04 12:01 AM


All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"