LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Auto fill drop down stops at second cell

Excel 2003 SR1

I have two adjacent columns(V,W). V4 contains this formula:
=IF(AND($Q5="Y",$J40,$J4<3),"Y"," ") I can highlight V4, double click on
the +, and it will draw the formula down to the end of the data. (as does
columns T,U)

W4 contains this formula:
=IF(AND($Q3="Y",$J46),"Y",""). When I highlight W4, and double click on
the +, it stops at W5. Columns X,Y,Z also stop at row 5.

I've tried putting in a helper column in front of W, with a 1 in each cell,
but that doesn't work. I need these columns to extend the formula to the end
of the data. This is a template for 5 different length files, and I'm going
to record a macro to massage the data, but need this problem solved first.

TIA,

CaroleO


 
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
Drop Down Lists and Auto Fill Ken New Users to Excel 6 December 14th 09 05:34 PM
Auto Fill from Drop Down list Brian Excel Worksheet Functions 3 November 2nd 06 09:56 PM
HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN. Trenner Excel Discussion (Misc queries) 2 May 16th 06 12:33 PM
Auto Fill Cells, When Choosing From Drop-Down List... doc1975 Excel Worksheet Functions 1 January 11th 06 02:36 AM
Creating an auto fill or drop down Steve Excel Discussion (Misc queries) 2 July 7th 05 12:24 AM


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