I am have created a speadsheet to capture client information including sales
info (one client per row). To keep this simple for my users I want to create
a form that will capture each cell and populate the sheet like a list.
Clicking data then form doesn't work. Please help. I'm good at excel but have
no idea in VBA so if this is the answer please talk to me like i'm stupid!

Thanks
--
Gordon

Hi,
Send me the worksheet so I can see the layout structure.

See my stuff at:
http://www.geocities.com/excelmarksway

- Mark



-----Original Message-----
I am have created a speadsheet to capture client
information including sales
info (one client per row). To keep this simple for my
users I want to create
a form that will capture each cell and populate the sheet
like a list.
Clicking data then form doesn't work. Please help. I'm
good at excel but have
no idea in VBA so if this is the answer please talk to me
like i'm stupid!

Thanks
--
Gordon
.

Look at Data|form. Maybe you don't need any VBA at all.

If you like it, but it's too limited, you can try John Walkenbach's enhanced
dataform:
http://j-walk.com/ss/dataform/index.htm

And if you want to learn a bit about userforms, visit Debra Dalgleish's site:
http://www.contextures.com/xlUserForm01.html

Gordon wrote:

I am have created a speadsheet to capture client information including sales
info (one client per row). To keep this simple for my users I want to create
a form that will capture each cell and populate the sheet like a list.
Clicking data then form doesn't work. Please help. I'm good at excel but have
no idea in VBA so if this is the answer please talk to me like i'm stupid!

Thanks
--
Gordon

--

Dave Peterson

Hi

Assuming you have a unique identifyer for each customer. Make sure that
identifyer is in the lefthand most column.
Then you can design another sheet and use multiple vlookups to populate this
other sheet based upon one cell. You could also validate the data in this
one cell so that you can select the customers from the list of unique
identifyers.

I have used this technique for a smiple purchase order recording system
where the identiyer is the purchase order number and the form is designed to
look like a printed purchase order.

Regards

Chris


"Gordon" wrote in message
...
I am have created a speadsheet to capture client information including
sales
info (one client per row). To keep this simple for my users I want to
create
a form that will capture each cell and populate the sheet like a list.
Clicking data then form doesn't work. Please help. I'm good at excel but
have
no idea in VBA so if this is the answer please talk to me like i'm stupid!

Thanks
--
Gordon