Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
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:
|
#4
|
|||
|
|||
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:
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data passed to spreadsheet from Form. How to reload the spreadsheetdata into the Form? | Excel Programming | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
How do I create a User form to input Data into an Ecel spreadsheet | Excel Programming | |||
How do I create a 1pg form for each row of data in a spreadsheet? | Excel Discussion (Misc queries) | |||
Can I create a FORM (that I can modify etc) from an existing spreadsheet? | Excel Programming |