Urgent Help Required!!!! (Please)

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

I am not exactly sure what you are trying to achieve, but here are some useful formulae:

If Sheet1 contains the numbers 1 to 500 in the cells A1 to A500

Then the formula =Min(Sheet1!A1:A500) will return 1
and the formula =Max(Sheet1!A1:A500) will return 500
so if you put these formulae in Sheet2 at A1 and C1 and enter "to" in B1 then it would show "1 to 500" at the top of the sheet.

You can also enter the number 156 at A3 and the formula =VLOOKUP(A3,Sheet1!A1:B500,2 false) in B3, which will look up any entry that you made in sheet 1 column B against the number 156 in column A.

Hope this helps a bit

All the best

Andrew

Cindy, please read the Forum Rules about thread titles, and then edit your thread title to be descriptive of your problem.