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