Is this possible??

[DB]

I have been given the job of booking vouchers in at work.....they come in
pads of 20 and i have to list 200 books manually once a month.

The vouchers are all serial numbered and have to be booked in by serial
number and as I issue them ,they are booked out (you still with me?)

The voucher numbers will be something like 123501 - 123520, then the next
pad is 123521 to 123540 etc etc.

When I get them in I get an invoice which shows me the start and end
numbers, i'd love to try and set something up where i could enter the start
and end serial number and excel would create a sheet with all these numbers
enterred for me.

My worksheet displays the date i receive these vouchers in, the start number
and then the end number i.e. ...........................

Date Start Serial No End Serial No
25 Nov 05 123501 123520
" " " 123521 123540



Can any kind person suggest a way of helping me achieve this, my experience
of Excel is a bit limited but i'll have a crack at anything.

Many Thanks

Dave

[DB]

Sussed it - thanks

DB


"DB" <db002a3121(NOSPAM)@blueyonder.co.uk> wrote in message
news:[email protected]...
>
>
> I have been given the job of booking vouchers in at work.....they come in
> pads of 20 and i have to list 200 books manually once a month.
>
> The vouchers are all serial numbered and have to be booked in by serial
> number and as I issue them ,they are booked out (you still with me?)
>
> The voucher numbers will be something like 123501 - 123520, then the next
> pad is 123521 to 123540 etc etc.
>
> When I get them in I get an invoice which shows me the start and end
> numbers, i'd love to try and set something up where i could enter the
> start and end serial number and excel would create a sheet with all these
> numbers enterred for me.
>
> My worksheet displays the date i receive these vouchers in, the start
> number and then the end number i.e. ...........................
>
> Date Start Serial No End Serial
> No
> 25 Nov 05 123501 123520
> " " " 123521
> 123540
>
>
>
> Can any kind person suggest a way of helping me achieve this, my
> experience of Excel is a bit limited but i'll have a crack at anything.
>
> Many Thanks
>
> Dave
>
>
>
>
>