Hi all

I am entering some voucher numbers into a cell and wish to copy it down to
autocomplete the rest, however, I can't seem to get it to work. The numbers
I have entered a-

100-199
200-299

so I was hoping I could drag it down to enter 300-399, 400-499 and so on but
it doesn't seem to understand what I am trying to do.

Any ideas how I can solve this?

Thank you
Louise

Hi Louise

One way
Assuming your exiting data starts in A1, insert 2 columns in front of
your existing column
In A1 enter 100, in B1 enter 199
In A2 enter = A1+100, in B2 enter = B1+100
Copy both down as far as required.
In cell C1 enter
=A1&" - "&B1
Copy down
Copy whole of column C and Paste SpecialValues
Delete columns A&B

--
Regards

Roger Govier


"Louise" wrote in message
...
Hi all

I am entering some voucher numbers into a cell and wish to copy it
down to
autocomplete the rest, however, I can't seem to get it to work. The
numbers
I have entered a-

100-199
200-299

so I was hoping I could drag it down to enter 300-399, 400-499 and so
on but
it doesn't seem to understand what I am trying to do.

Any ideas how I can solve this?

Thank you
Louise

That worked a treat! Thank you.

Louise

"Roger Govier" wrote:

Hi Louise

One way
Assuming your exiting data starts in A1, insert 2 columns in front of
your existing column
In A1 enter 100, in B1 enter 199
In A2 enter = A1+100, in B2 enter = B1+100
Copy both down as far as required.
In cell C1 enter
=A1&" - "&B1
Copy down
Copy whole of column C and Paste SpecialValues
Delete columns A&B

--
Regards

Roger Govier


"Louise" wrote in message
...
Hi all

I am entering some voucher numbers into a cell and wish to copy it
down to
autocomplete the rest, however, I can't seem to get it to work. The
numbers
I have entered a-

100-199
200-299

so I was hoping I could drag it down to enter 300-399, 400-499 and so
on but
it doesn't seem to understand what I am trying to do.

Any ideas how I can solve this?

Thank you
Louise

"Louise" skrev i en meddelelse
...
Hi all

I am entering some voucher numbers into a cell and wish to copy it down to
autocomplete the rest, however, I can't seem to get it to work. The
numbers
I have entered a-

100-199
200-299

so I was hoping I could drag it down to enter 300-399, 400-499 and so on
but
it doesn't seem to understand what I am trying to do.

Any ideas how I can solve this?

Thank you
Louise


Hi Louise

Another option:

In A1:

=ROW()*100&"-"&ROW()*100+99

Copy A1 down with the fill handle (the little square in
the lower right corner of the cell).

--
Best regards
Leo Heuser

Followup to newsgroup only please.

Try this:
=LEFT(A2,FIND("-",A2)-1)+100&"-"&RIGHT(A2,LEN(A2)-FIND("-",A2))+100
copy all the way down

-------------
mama no teeth

"Louise" wrote:

Hi all

I am entering some voucher numbers into a cell and wish to copy it down to
autocomplete the rest, however, I can't seem to get it to work. The numbers
I have entered a-

100-199
200-299

so I was hoping I could drag it down to enter 300-399, 400-499 and so on but
it doesn't seem to understand what I am trying to do.

Any ideas how I can solve this?

Thank you
Louise