Creating an easy to enter database in excel

**007juk** · 10-14-2007, 07:31 PM

Hi,

I have a 2 page word doc that I would like to transfer into excel, but would like to use the data in docs to create a database and another sheet with vlookup formulas. The doc is re-written each time a new street is assessed and given ref no. Some of the boxes on the word doc contain 8 lines of text.

I have created a sheet in excel with a template of the word doc and have added vlookups to populate cells etc. When I created database 'sheet2' it started to get quite big e.g there could be 8 rows to be populated that means creating 8 columns in sheet2. I have used data valadation to quickly select data, but still takes some time. I had a look at the 'form' option, but you have to enter the data each time you select. Is there anyway of making the database smaller at the moment it ranges from A - az and if I need to populate 8 rows it means tabing over 8 times and seleting data.

Thanks.

**tuph** · 10-15-2007, 02:33 AM

It might be easier to work out if you can put both the Word doc and the Excel workbook into a zip file and attach it.

**007juk** · 10-15-2007, 04:49 PM

No probs -hope this explains a bit more, thanks.

**tuph** · 10-15-2007, 06:30 PM

I think you will need a macro or some more detailed VBA to transfer the data to the second worksheet. This is beyony my level of expertise, but I'm sure someone else will be able to help.