Hi.

This is my first post so please bear with me.

I am trying to create a spreadsheet/ database of ticket numbers (i.e. 1 -1000).

What I want to be able to do is enter the first number and the last number in the range and have the spreadsheet 'remember' the numbers in between.

For example:

Let's say I have entered the numbers 1 to 500.

On my screen (and if I print the worksheet) I only want to see the numbers 1-500.

However I wish to look at number 156.

Is there any way this can be done?

Apologies if this makes no sense at all. Please post back if further details are required.

I am using 2007 version.

Thanks in anticipation
CindyB