Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Location: Shropshire; UK
Posts: 3
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default 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


  #3   Report Post  
Junior Member
 
Location: Shropshire; UK
Posts: 3
Default

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.

Quote:
Originally Posted by GS[_2_] View Post
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
  #4   Report Post  
Junior Member
 
Location: Shropshire; UK
Posts: 3
Default

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.

Quote:
Originally Posted by GS[_2_] View Post
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
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data passed to spreadsheet from Form. How to reload the spreadsheetdata into the Form? Morlin Excel Programming 5 July 20th 09 10:59 PM
excel form. Need data extracted to spreadsheet each time a form co MikeR-Oz Excel Discussion (Misc queries) 4 April 5th 09 05:18 AM
How do I create a User form to input Data into an Ecel spreadsheet JohannM Excel Programming 1 September 7th 06 05:25 PM
How do I create a 1pg form for each row of data in a spreadsheet? khoffmann64 Excel Discussion (Misc queries) 0 April 20th 06 08:43 PM
Can I create a FORM (that I can modify etc) from an existing spreadsheet? bruce Excel Programming 0 June 9th 04 09:27 PM


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"