Hi All,

I have a spreadsheet with 27 columns where each bottom row is a
transaction. There are about 10 common scenarios where transactions
are entered in only certain columns.

To simplify things, I was hoping to make a form for each scenario
using only those columns. Is this possible to do using the Data
Form option without having to know VBA? Since I don’t know VBA, this
is probably wishful thinking.

Even if I can only get one form (the most common scenario) to work, it
will be useful. But then, what’s the best way to get my dropdown
lists to work because they don't?

I thought it best to know before I started into it and found it wasn’t
going to work.

Thanks for your advice,

Michele

when you say transaction,
what do mean 'calculation' a text or word symbol,
in other words please elaberate on 'transaction'

Second, what are you trying to achieve with your drop downs
Are you using 'data validation' are you wanting dependet drop downs
ie
in col a there is a drop down
Apples
Oranges
Bannas

If you select Apples, in col B
a drop of price 1 dollar 2 dollars and 3 dollars would appear

but if selected bannas in col B
4 dollars 5 dollars and 6 dollars would occour

"mjones" wrote:

Hi All,

I have a spreadsheet with 27 columns where each bottom row is a
transaction. There are about 10 common scenarios where transactions
are entered in only certain columns.

To simplify things, I was hoping to make a form for each scenario
using only those columns. Is this possible to do using the Data
Form option without having to know VBA? Since I dont know VBA, this
is probably wishful thinking.

Even if I can only get one form (the most common scenario) to work, it
will be useful. But then, whats the best way to get my dropdown
lists to work because they don't?

I thought it best to know before I started into it and found it wasnt
going to work.

Thanks for your advice,

Michele
.