Search results

@PaulF I have to try the google API code to see if is accurate and works. @vletm Thank you for the tips and help. King regards, Lomer

Thank you very much Paul for your dashboard. The main problem in my case is the fact that the excel formula doesn't take in consideration the road (mountains, etc.) only a straight line from point A to point B. To understand better my situation: I have different products in different sites...

That's brilliant. I didn't think to use Index and Match. Thank you so much.

Hi guys, I need some help with a formula that calculate the distance from point A to different points B C D E F G using lat and lon and show the closest one. Please find an example attached. Thank you very much for your help.

Yes is my fault and you're 100% right. Sorry for my mistake. Thank you very much for you help and support. I wish you a great weekend ahead!

Luke, This is the same code as the cbSearch has. I hope that this prtscreen to help you understand what i want. You helped me with 1. 2. 3. 4. 5. - the code is working very well. But for Submit button cannot be the same code like Search has, cause will perform a second search and i don't want...

Dear Luke, Can you help me write the code for the Summit approval button? fcell(strName, 29).Value = Me.tbSDMAppr.Value fcell(strName, 31).Value = Me.tbComApp.Value I mean, i want to be able to change the information in this 2 columns when the Summit approval is clicked. The update or the...

Dear Luke, Isn't this what i want but is very good because on the search tab i will lock the textboxes and let only the comboboxes enable. What i want is to update the information in the row where the value was found when SUBMIT APPROVAL button is clicked. I don't know how to explain better...

Ok. Let me explain better. So my userform has 2 different thing. 1. Add part This part will be used only by the normal users when they want to submit the new order by filling the textboxes with the right information. After they will use the Add button to paste the information in "Orders". The...

Dear Luke, You're a genius. I have modify the code and now all my textboxes are filled with the columns that i want. Now the person that need to approve the order can search and will find all the data with the order ref number and the account name. In my form i have 2 drop list : SDM and...

Thank you very much Luck for your help. I already tested the code and is working. What i want after the record was found is to populate the textboxes in the userform. For exemple: if the value was found on row 2 then textbox..= with Cell A2. Do you think that will be possible? Many thanks for...

Hi guys, I've been start recently to work with VBA and i was able to create a userform that will populate "Orders" based on what the users will write in the userform. Then i had to make a search function based on order ref number and account name that will populate the userform with the data...

@vletm The only user will be me. That's why will be easy in case that I'll delete any formula or smthing, because i will know what to do. Tip 1: Use the drop down lists for Document Name and Location in the License and Certifications sheet to be faster to fill. Tip 2: write a formula that...

@vletm First of all, thank you for your time. I think that the final version made by @eibi is very very useful because for there you can add, delete or modify anything. For example, in Upcoming Events by date, I've added a new column "company" and made a formula to lookup for the employee name...

@eibi. I tested all the things and everything seems to work well. The only issue was that in the dashboard -> Upcoming Events by Date -> Location if a employee had 2 different documents for 2 different location with the same date, the IF will display the same text "Multiple Licenses" for the...

@vletm I found 1 dashboard in the forum and i can use it for what i need. I think i can modify that one to my needs, because to think one from the scratch is very difficult. Thank you very much!

@vletm the problem was that i have and add-on - ABP that didn't allow the page script to display the little window with the upload document. I disable the add-on and this is the sample.

@vletm...i tried to upload a file with a sample but i don't know why when i press "Upload a file" and i go where is my sample, i cannot find my document(i saved the sample in different format and still the same) Yes, you're right, but i cannot upload a sample.

Dear Eibi, You did an excellent job and i appreciate that. many many thank. This dashboard is so perfect and i think that from here i can modify the formulas by myself. For me that hard part was to try to think what was your logic when you made the formulas and rewrite the code without the...

Hi all, Can someone help me with a dashboard that will display the employee documentation for renewal and the companies documentation for renewal? For the employees i have 5 different documents and 7 locations. 2 of these documents need to be for each location. Companies: i have 9 companies...

Hi eibi...can you help me with smthing?

Hi eibi...I'm in the same situation with hrtrsmom7. i downloaded the last hntrsmom7.xlsx to use the same report for my daily tasks. i need the same things like him but the last sheet with performance doesn't apply to my needs but i cannot delete because all the formulas will have errors. do you...