Autofill

[lordku]

I want to autofill a sheet with sets of 3 numbers all the way down however having several issues it is putting decimal points in after it which I think is messing with the pattern.

For example:

100
100
100
101
101
101
102
and so on

I have tried grabbing several cells to get it to work however no luck any help would be great.

 

[braindiesel]

If you assume the 100's are in cells A1, A2, & A3
in cells A4 put =A3+1
in a5 put =A4
in a6 put =A4
Select A4:A6

Drag down

Does that work?

 

[MrKowz]

How far down do you want to go?

 

[Cloverken]

In cell A1 type 100
In cell A2 type =A1
In cell A3 type =A1

Select cells A1:A3 and drag down.

When you get to end of numbers that you want you can select column and select "Copy" then "Paste Special" check "Values".

 

[lordku]

Thanks braindiesel that worked perfectly. For others that replied Thank you...

Thanks Cloverken also that methods works equally well.

I was going from 105150 - 215150

lordku