Creating a dynamic database

%3CLINGO-SUB%20id%3D%22lingo-sub-2597969%22%20slang%3D%22en-US%22%3ECreating%20a%20dynamic%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597969%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20hope%20someone%20can%20help.%3C%2FP%3E%3CP%3EI%20have%20created%20a%20workbook%20(The%20Master%20Quote%20System)%20to%20dynamically%20calculate%20Commercial%20Insurance%20Quotations.%3C%2FP%3E%3CP%3EIt%20has%20several%20dynamic%20worksheets%20within%20the%20workbook%20subject%20to%20how%20certain%20questions%20are%20answered.%20Within%20the%20same%20workbook%2C%20I%20have%20created%20a%20single%20line%20Database%20that%20collects%20all%20the%20information%20captured%20from%20each%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20built%20a%20second%20workbook%20(The%20Master%20Database)%20that%20replicates%20the%20Database%20content%20from%20the%20Master%20Quote%20System%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20the%20second%20Workbook%20to%20do%2C%20is%20dynamically%20record%20(next%20row%20down)%20the%20data%20input%20from%20the%20Master%20Quote%20System%20everytime%20it%20is%20completed.%20Here%20are%20my%20question(s)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Do%20I%20need%20to%20save%20a%20version%20of%20the%20Master%20Quote%20System%20for%20each%20individual%20quote%20and%20create%20a%20new%20file%20name%20%3F%3C%2FP%3E%3CP%3E2.%20How%20do%20I%20get%20the%20data%20from%20the%20above%20quotation%20to%20sequentially%20drop%20into%20the%20next%20row%20down%20on%20the%20Master%20Database%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20coded%20the%20Master%20Database%20to%20transfer%20the%20data%20from%20the%20Master%20Quote%20System%20-%20which%20works%20fine.%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20if%20I%20save%20the%20Master%20Quote%20System%20in%20the%20name%20of%20the%20individual%20client%2C%20The%20Master%20Database%20picks%20it%20up%20in%20the%20name%20of%20the%20client.%20I%20need%20it%20to%20then%20pick%20up%20the%20next%20client%20quote.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%20or%20am%20I%20approaching%20the%20process%20in%20the%20wrong%20way%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJonathan%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2597969%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2602871%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20dynamic%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2602871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20Thanks%20for%20the%20quick%20response.%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20do%20this%20as%20a%20Teams%20meeting%20and%20for%20me%20to%20share%20via%20screenshare%20and%20talk%20you%20through%20it%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Workbook%20I%20have%20built%20is%20confidential%20in%20terms%20of%20it's%20new%20and%20different%20and%20tackling%20a%20large%20gap%20in%20the%20UK%20commercial%20insurance%20market%20-%20so%20as%20you%20can%20imagine%20I%20am%20a%20little%20nervous%20sending%20out%2C%20as%20it's%20a%20major%20part%20of%20my%20new%20company%20offering.%20Appreciate%20that%20this%20forum%20is%20also%20there%20to%20help%20others%20but%20i%20need%20to%20be%20really%20careful.%20In%20other%20circumstances%20I%20would.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJon%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2598015%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20dynamic%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2598015%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118454%22%20target%3D%22_blank%22%3E%40Jon_Hemmings%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20post%20copies%20of%20your%20actual%20spreadsheets%3F%20Or%2C%20if%20the%20originals%20include%20confidential%20or%20proprietary%20info%2C%20then%20post%20mockups%20that%20use%20false%20names%2C%20but%20otherwise%20replicate%20the%20layouts%20that%20you're%20referring%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20should%20indeed%20be%20possible%20to%20accomplish%20what%20you%20want%2C%20but%20we%20need%20to%20gain%20a%20lot%20more%20clarity%20on%20exactly%20what%20that%20is....sadly%20words%20alone%20don't%20always%20give%20that%20clarity.%20And%20images%20add%2C%20but%20the%20best%20would%20be%20an%20actual%20example%20of%20the%20workbook(s)%20that%20you're%20working%20with.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2604175%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20dynamic%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2604175%22%20slang%3D%22en-US%22%3EThat%20would%20be%20possible%2C%20but%20from%20what%20you%20just%20said%20it%20seems%20far%20more%20appropriate%20for%20you%20to%20find%20and%20hire%20an%20Excel%20expert%20there%20in%20the%20UK%20to%20work%20with%20you....I%20just%20volunteer%20some%20time%20here%20to%20help%20individuals%20(who%2C%20yes%2C%20sometimes%20have%20work-related%20workbooks).%20What%20you're%20doing%20requires%20and%20deserves%20a%20deeper%20commitment.%3C%2FLINGO-BODY%3E
New Contributor

Hi, I hope someone can help.

I have created a workbook (The Master Quote System) to dynamically calculate Commercial Insurance Quotations.

It has several dynamic worksheets within the workbook subject to how certain questions are answered. Within the same workbook, I have created a single line Database that collects all the information captured from each worksheet.

 

I have built a second workbook (The Master Database) that replicates the Database content from the Master Quote System workbook.

 

What I want the second Workbook to do, is dynamically record (next row down) the data input from the Master Quote System everytime it is completed. Here are my question(s)

 

1. Do I need to save a version of the Master Quote System for each individual quote and create a new file name ?

2. How do I get the data from the above quotation to sequentially drop into the next row down on the Master Database?

 

I have coded the Master Database to transfer the data from the Master Quote System - which works fine. 

But, if I save the Master Quote System in the name of the individual client, The Master Database picks it up in the name of the client. I need it to then pick up the next client quote.

 

Is this possible or am I approaching the process in the wrong way?

 

Regards

 

Jonathan

 

 

 

4 Replies

@Jon_Hemmings 

 

Is it possible to post copies of your actual spreadsheets? Or, if the originals include confidential or proprietary info, then post mockups that use false names, but otherwise replicate the layouts that you're referring to.

 

It should indeed be possible to accomplish what you want, but we need to gain a lot more clarity on exactly what that is....sadly words alone don't always give that clarity. And images add, but the best would be an actual example of the workbook(s) that you're working with.

@mathetes 

 

Hi, Thanks for the quick response.

Is it possible to do this as a Teams meeting and for me to share via screenshare and talk you through it? 

The Workbook I have built is confidential in terms of it's new and different and tackling a large gap in the UK commercial insurance market - so as you can imagine I am a little nervous sending out, as it's a major part of my new company offering. Appreciate that this forum is also there to help others but i need to be really careful. In other circumstances I would.

 

Let me know.

 

Regards

 

Jon

 

 

 

 

That would be possible, but from what you just said it seems far more appropriate for you to find and hire an Excel expert there in the UK to work with you....I just volunteer some time here to help individuals (who, yes, sometimes have work-related workbooks). What you're doing requires and deserves a deeper commitment.
Ok that makes sense. Thankyou anyway,