Could you use an input box
or just a table
truck gallons
1
2
and enter without being fancy

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"David W" wrote in message
...
Got a Question
I have got 12 columns and 160 rows
I need to use an input box in each cell so you will know what cell your
in,
know here's the trick
I know that I can use validation to do this by copying and doing a paste
special, BUT how do you get the contents of the message to grow by one
Example
if A1 had validation and it read
"Truck 1"
"Enter Gallons"
how could you get it to change to
"Truck 2"
"Enter Gallons" in A2 ;and so on
This one is a little tricky for me