Hi!

My aim is to have a user to fill out a form on "sheet A", which I am to
convert into a specified number tickets. I want everything to be
constant, except the increasing ticket number.

Because of desired layout, all text on the tickets must be centered...
so I've had to use some combined cells.

Situation: Column A contains values: 1,2,3,4,5....
B1: <text
B2: <text
B3: =Sheet1!$A$1&": "&$A1

If I mark these 3 cells and use the handle to drag out more, I need to
get number "2" in B6 and not "5".

* Can anyone think of a better way of solving this?

* Can I do something like this: =Sheet1!$A$1&": "&$A(1+1)

Grateful for any suggestions!


--
Foobi
------------------------------------------------------------------------
Foobi's Profile: http://www.excelforum.com/member.php...o&userid=19784
View this thread: http://www.excelforum.com/showthread...hreadid=510507