LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35
Default autofill down won't work!!!!

I have input data in columns A through D and then formulas in columns E
through H that calculate off the data in columns A to D. For the formulas, I
just double click the bottom right hand corner of the cell box and it
autofills down. The next time I enter data in columns A through D, the
formulas in columns E through H automatically calculate for me. EXCEPT one
formula, it will not autofill, I have to double click the bottom right corner
of the cell above for this formula to calculate in the present row. The
formula is very simple too, it is just a cumulative profit. So if profits
are in column G, and column H is cumulative, and the formula to be filled is
in cell H33, it would just be H32+G33. Why is this one formula not
autofilling????
 
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
Macro to update a column in a work based on another work sheet WickerMan New Users to Excel 1 December 4th 09 12:58 PM
Autofill does not seem to work when dragging right karlos Excel Discussion (Misc queries) 2 August 7th 08 06:30 PM
Why doesn't autofill work in Excel? trainer07 Excel Discussion (Misc queries) 1 July 19th 07 08:47 PM
Counting dates in multiple work sheets and work books Savage Excel Discussion (Misc queries) 0 December 19th 05 11:41 PM
Autofill: Need to autofill one week block, (5) weekday only into cells. dstock Excel Discussion (Misc queries) 1 June 17th 05 08:21 PM


All times are GMT +1. The time now is 09:23 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"