Solved

Best way to populate an Excel form from an Excel table

Posted on 2014-02-23
4
200 Views
Last Modified: 2014-03-18
Hello,

I'm looking for some suggestions on the best way to populate a form from a database or table in Excel. The intent, after populating the forms, is to send them to their respective named individuals for proofreading and updating of the information. Here's the table:

aThe tricky part for me is that the table is grouped by family (there are several hundred) and then within the groups, sorted by head of the household, spouse (if any), children (if any) in order of age. So in the table, column A is a general index and column B is the family numbering.

For example, the first five entries (red index 1-5) are all in the Baggins family with Dad listed first, mom listed second, and the three kids following in order. Red index 6 is Mr. Fresh Forest who is single with no kids, and the last four entries (red index 7-10) are the Grimp family.

Note that the information in columns C-F is common to all members of a particular family and the content of the remaining columns (G-O) is specific to individuals.

Here is the form which I'm hoping is self-explanatory. (By the way, I'm sending it as an Excel file and as a PDF so that people can print it and make comments by hand if they want):

bThe family name is simply the combination of the parents' names or single head of household. The form is set up so that members of a family are identified by the number of their position in the family from column B in the table. Therefore, section "INDIVIDUAL #1" could be blank, contain the spouse's information or the oldest child's information depending on the makeup of the family.

This table sample shows data in all fields however the actual database is full of blank cells and therefore the respective form fields will be blank.

Of course, when the forms are completed and returned, the information will need to be put into the database manually — unless of course someone knows of a very slick way to sort of import the updates.

Thanks
0
Comment
Question by:WeThotUWasAToad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 1

Expert Comment

by:cben
ID: 39882601
Try this.
No time now to explain - just that data is in Table so new rows are added automatically.
Choose specific family in top row of output sheet.
Hope it helps
Chris
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 250 total points
ID: 39882958
If you're sending as an Excel file, why not just keep the info in the table format you have now?  Doing that will make it much, much easier to write a macro later to automatically harvest the edits...
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 250 total points
ID: 39885397
Might be worth considering a true database or at least a true database format within Excel.

If in Excel each group would have a common id field, for example the Baggins family, rather than having individual id's 1 to 5 and then family id 1 to 5, they would have the individual id's 1 to 5 and would also have a family group id to append to their id within family eg

Record       Family#       Family Group    Name
1                BAGGINS1   BAGGINS           Dad
2                BAGGINS2   BAGGINS           Mum

You can then sort/group on Family group ID and create records accordingly.

If using Access, I am sure it would be a fairly simple to create a form to represent the data bu I don't have a copy of Access to hand to try.

Thanks
Rob H
0
 

Author Closing Comment

by:WeThotUWasAToad
ID: 39938480
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question