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

[BSmith]

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

 

[GS]

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

 

[BSmith]

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

Hope this clarifies it.

;1610183']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.discussio

 

[GS]

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