How to extract data from a spreadsheet into a form/create form from spreadsheet data
 

I have a spreadsheet which contains client data in columns with each row for a different client.
I want to either extract various data from this sheet to individual client forms but am unsure about the best way to achieve this. I also don't have VBA experience in case this an option!
Any advice would be most welcome.

How to extract data from a spreadsheet into a form/create form from spreadsheet data
 

BSmith pretended :
I have a spreadsheet which contains client data in columns with each
row for a different client.
I want to either extract various data from this sheet to individual
client forms but am unsure about the best way to achieve this. I also
don't have VBA experience in case this an option!
Any advice would be most welcome.

Explain what tou mean by "client form"!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Hi Garry, this form is intended to be a form prepared for each client/member which is populated with info from the spreadsheet and then can be extended further with additional information.

Hope this clarifies it.

Hi Garry, this form is intended to be a form prepared for each client/member which is populated with info from the spreadsheet and then can be extended further with additional information.

Hope this clarifies it.

How to extract data from a spreadsheet into a form/create form from spreadsheet data
 

Hi Garry, this form is intended to be a form prepared for each
client/member which is populated with info from the spreadsheet and
then
can be extended further with additional information.

Hope this clarifies it

Not really! I have to assume the 'form' is a predesigned worksheet OR a
predesigned userform. (symantecs!)

Assuming a predesigned worksheet, I need to know the structure/layout
of the target 'form' for each client. The approach would be to step
through each record and put the contents into the respective client
'form' where the data should be positioned.

It might be better to post a link to where your file can be downloaded
so people who can help can see the scenario for what you're trying to
accomplish.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion