back end database within excel workbook

[coasterman]

Hi,

I'll do my best to explain this particular scenario

I have a workbook which based on the user input in about 20 cells crunches a series of data tables contained about 30 sheets. The user input cells are for the purposes of aesthetics in non consectuvie cells resemble input forms and are over a number of sheets.

The main ‘home’ sheet asks for details about an individual (in this case a claimant) date of birth, date of injury, date of accident etc. With this basic information a number of figures are then extracted from the statistical tables with an INDEX, MATCH formula. Those figures are then employed to work with some financials which the user supplies and a second phase of calculation is made.

All works fine but of course these 20 or so cells need to be input each time a new claimant is tested.

How difficult would it be (without ODBC to Access for instance) to build a back end database within the same workbook which would catch this user input and then have it imported back into the user entry cells on demand say by claim number?

I’m really looking to see first if it is possible and secondly what would be the key stages of the process.

Thanks

[royUK]

Probably simple enough with a table of data & VLOOKUP

[royUK]

Probably simple enough with a table of data & VLOOKUP

Simple example here

[coasterman]

Hi,

I think I get what you mean. The Claim number in my Users sheet would be the value to match in the Vlookup and the data in the same row in the sheet containing the data table would become the values in the user sheet.

How to set those values to the User sheet (as they can't contan lookup forumlas) is where I suspect I may struggle. I've just been shown the use of With statement and setting the value to a destination cell but for static cell locations. Choosing a row from an array of data is something I have never attempted. I'll do some research before posting again and see how far I can get.

Thanks again

[royUK]

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.

You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file.

To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.