Search : in
By :

Auto Fill the Range Between 2 Cells

Last answer on Jun 1, 2009 1:47:46 am BST JIN, on Feb 8, 2009 4:52:20 am GMT 
 Report this message to moderators

Hello,

My Question is

I Have Put One Range Like " 1 " in One cell and ending series " 10 " in next cell . Now i want the excel To Auto Complete the Range from 1 to 10 and put it in another cell . Please tell me how can i do that.

Secondly If i only put one Data in One cell how can i make excel to auto fill the Entire series Automacially without using Autofill option manually but dragging the cell horizontally or vertically.

Your Help will be appreciated

Configuration: Windows XP
Firefox 3.0.6

Best answers for « Auto Fill the Range Between 2 Cells » in :
[VBA] Deleting a word in a range of cell Show [VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
Excel Macro - Set and autofill a range? Show
Compare cell Values (Solved) Show
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Download AutoClick ShowIf the manipulation of the mouse falls to you, if you are simply lazy to use it or if you feel more comfortable with the keyboard, then use Autoclick. When the movement of the gun-layer stops, AutoClick counts a space of time and orchestrates a mouse...
Download Webm8 Portable Edition Show
Download Rumblepadā„¢ 2 Vibration Feedback Gamepad Show
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

Helper, on Feb 8, 2009 11:45:10 pm GMT
  • +1

I'm not sure this answers your question, but this will fill the range from A1:A10 with the numbers
one throught ten.

Private Sub FillRange()

Dim i
i = 1

Do While i < 11

Range("A" & i) = i

i = i + 1

Loop

End Sub

I'm not sure about your second question. If you put data in one cell and then use Autofill, Excel assumes that is the data you want to fill in the range.
Example:
If you put the number 1 in cell A1 and then use autofill to range A10, Excel will fill the whole range with the number 1.

If you put the number 1 in cell A1 and the number 2 in cell A2, highlight both cell A1 and A2 then use Autofill,
then you are giving a "Step" value, so excel will fill the range 1,2,3,4....... until you stop Autofill.

   
Reply to Helper

2

JIN, on Feb 9, 2009 5:10:29 am GMT
  • +1

Can you please eloborate a bit more where to use this dim function

Perhaps , an example will be very easy for me to understand . If Possible can you please make an excel file and share it here so that i can have a look on it and understand . with the same scenario which i mention earlier.

   
Reply to JIN

3

Helper, on Feb 10, 2009 12:12:58 am GMT

Example given in the following file.
I have given a brief description of the code.
Click on the command button in the file to see the code run.



[URL=http://www.4shared.com/file/86380706/bb072625/Example.h­tml]Example.xls/URL

   
Reply to Helper

4

JIN, on Feb 10, 2009 4:52:12 am GMT

Nope i still cant get it.

You have mention this Forumula Earlier.

Please make an Example like this

I have Two Colums

In Cell A1 I ENTER NUMBER 100
IN Cell B1 I Enter Number 150

Now i want the Entire Number in between Cell A1 And Cell B1 to be Appear Automatically in Cell A3 or Any Other cell where i want to Put , without doing Manually

Please make an excel and Share

   
Reply to JIN

5

Helper, on Feb 10, 2009 11:41:12 pm GMT
  • +1

I guess I'm having a hard time understanding.
If you just want to sum the numbers in A1 and B1 then type a sum formula in A2 such as,

=SUM(A1,B1)

See the attached file. Change the numbers in A1 and B1 to see if that is what you want.


[URL=http://www.4shared.com/file/87067689/e0a72449/Example.h­tml]Example.xls/URL

   
Reply to Helper

6

JIN, on Feb 11, 2009 2:22:30 am GMT

Nope thats a Sum fomula i know that

have a look at this


100 150

101
102
103
105
105
106
107

This Above range from 100 to 150 Should appear when i enter the first 100 and enter the Lase 150 .And this range i want it to appear in any cell where i want this range to appear when i enter the first and last number

   
Reply to JIN

7

Helper, on Feb 12, 2009 4:14:02 am GMT

Ok. Try this.
This time just click anywhere in the spreadsheet and click the command button. You won't have to type anything in.



[URL=http://www.4shared.com/file/87262008/21e2b35c/Example.h­tml]Example.xls/URL

   
Reply to Helper

8

JIN, on Feb 13, 2009 5:09:33 am GMT

Thanks dude .

u went on visual basic .

but i dont know that thingy. :(

   
Reply to JIN

9

 wow gold, on Jun 1, 2009 1:47:46 am BST

Wow gold<a href="http://www.inwowgold.com/">wow gold</a>, cheap wow gold <a href="http://www.inwowgold.com/">buy wow gold</a>

09.06.01T

   
Reply to wow gold
Ask your question Reply
They need your help