Search results

Ok. here is my last file.

I see! ok I understand how to add rows now. But I've got an error 9 with the script on the last row of the code : I tried to change the name of "Sheet2" by the name of my sheet : Réponses. It worked but got a funny thing also. You can see in the screenshot at A1 Place. If I tried to create a...

Yay !! It work ! The summary table is really awesome, I will learn a lot from it ! Just a last request, I've added a few more columns following your logic ( Leg3 To, Leg 3 From, Leg4 from, Leg4 to plus km and time) in my file, but it doesnt fill any info in it. I've tried to look in the macro...

Thank you for your answer. Well, the issue isn't in Excel anymore with the table you propose. Actually we are not writing directly in Excel, but in form who is being writing in Excel by a workflow. It's in French, but you can see the kind of form : https://sani-care.ch/reservations/ (but...

Yes of course ! I've tried to work on my formular if I can link to this kind of table.. but it will take much work to do.. and I may be limited with structure... Meanwhile I'm looking to make it work, Is it possible to do it a simpler way ? even if it is just temporary. I've made an exemple...

I see... Well statistically speaking, this form of Table says everything. The purpose of this excel is for Billing the patient, so what is more important is to show total for each patient like my example in this file than all kms and time (but for statistics we'll need this info too). This...

Yes of course, I just did some basic table and linked it to a Jotform. Not sure if I understood what you mean correctly, I have tried to make an exemple in the file.

That's awesome ! It work great ! Is it also to make it a bit more complicated ? For example, sometimes we'll have to take our patient to a secondary destination or so. I've added news columns in the excel to show an example. If you're interested, I gladly PayPal you for your time, even if it...

Wow, much thanks for your work. I've tried your macro, here is a screen hop I put inside the file. If I don't put the API, an error come with a printed window, so first good point, when I put the API, and I press F5 to start, I've got nothing... I've put again the file with your macro and an...

I see. Each file I've tried with VBA never really worked well.. And I've got 0 skills on VBA yet.. Even so, I think the Webservice way for a start will be much easier and may be enough for a while until I've figured it out with VBA. I'll open this file once in a month to do the billing...

Hello ! Thanks for your answer. I've got the API from google and I saw the change. Well I'm not living in a big state and we're just build our startup this year, so if 25000 API transaction mean 25'000 Adress calculation, I will be rich as Bill Gates in 3 years haha ! IF 1 API transaction...

Hello everyone, First, I'd like to thanks Chandoo because I've found a great and also very simple file to calculate the distances and time with Google Maps in Excel. I'm trying to improve this file tu be used tu calculate every distance that come in a table when I recieve a Reservation...