LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Abode
 
Posts: n/a
Default Simple AutoFill Series Question

Hello. I just wrote a function that takes in two variables. One is the row
number, and the other is Regular Data. When I enter in the function into an
Excel Cell It looks something like this

=AutoFill(346,C345)

346 happens to be the current row number and C345 is the data it takes in.
How do I get it so 346 increments when I use to Fill handle. I tried just
using the fill handle and they all come out to be 346.. I've also put the
function into four or five cells with the correct Row number (346, 347, 348,
349) and used the fill handle but I only got it to repeat those four numbers.
Does anyone have any idea how I can get this to work. I bet the sollution
is very simple and right infront of my eyes (I've also clicked that little
icon after Filling and It doesn't have the Fill Series Radio button).
Anyway, Any help would be greatly appreciated.

Mark
 
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
Simple Question, Calculating Discounts WebLord Excel Worksheet Functions 3 March 17th 06 07:40 PM
Simple Question, display only part of a date in Number format DB Explorer Excel Worksheet Functions 6 March 17th 06 11:47 AM
Series of web queries: Autofill? Gent Excel Discussion (Misc queries) 1 March 13th 06 09:18 PM
Simple Question Brian Excel Discussion (Misc queries) 3 March 10th 06 10:12 AM
simple chart question Roney Charts and Charting in Excel 5 November 23rd 05 03:08 PM


All times are GMT +1. The time now is 02:17 PM.

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"