Тёмный
TheDataLabs
TheDataLabs
TheDataLabs
Подписаться
This channel is dedicated to support the professional community through our experience sharing in Excel, VBA, Dashboard creation, Report generation and Automation techniques.
Time Tracking Sheet in Excel and VBA
14:17
3 года назад
Комментарии
@fidhashirin
@fidhashirin День назад
worked. love it. thank you so much.
@thedatalabs
@thedatalabs 6 часов назад
Thanks for your feedback!
@AnkeshMauryaOfficial
@AnkeshMauryaOfficial День назад
My google sheet in not defined error aa rha h
@AnkeshMauryaOfficial
@AnkeshMauryaOfficial День назад
Reply mr
@jayjoarque4535
@jayjoarque4535 День назад
Thank you so much for this tutorial sir, Can you add Search and Print option for this sir? Thank you
@lizafortes3953
@lizafortes3953 2 дня назад
Thank you. I really appreciate you creating this tutorial. I created my very first time & motion tracker.
@CIROALABRESE
@CIROALABRESE 7 дней назад
Hi, this is possible to add the info to other document instead of other sheet ?
@toxicb4b0
@toxicb4b0 7 дней назад
I wanted to purchase on website but but because of al Ads on I won do it, sorry u ar very skilled but ur Ads is killing me 😮
@thedatalabs
@thedatalabs 5 дней назад
Sorry for the inconveniences. Can you let me know what exactly causing? I will talk to ad company and remove it.
@thedatalabs
@thedatalabs 5 дней назад
Hello There, we have removed Ads for the time being and highlighted the concern to the team.
@bartoszklepacki713
@bartoszklepacki713 8 дней назад
Hey. Is it possible to make hyperlink in Form Database window where after clicking employee name i will jump to Database sheet to this employee?
@as171987
@as171987 8 дней назад
How to validate on a protected sheet? Validation not working on protected sheet.
@TonyaGibbs-m6c
@TonyaGibbs-m6c 10 дней назад
Thank you for the tutorial. Does the Data sheet & the entry form need to be in the same spreadsheet, or can you reference the data sheet in the same google drive?
@YeshewasAkalu
@YeshewasAkalu 12 дней назад
more detailed tutorial need
@reddyca199o
@reddyca199o 12 дней назад
Who will provide full training? Please send me contact number
@nishandsouza
@nishandsouza 12 дней назад
Do u still work on VBSCRIPT. I have emailed on ur id
@positivexyz
@positivexyz 13 дней назад
Toda jor se bath karo bhai, why so low voice.
@khingjo44
@khingjo44 14 дней назад
can you please a tutorial about muliple data sheets transfer selected item with one userform in VBA
@SIRU_Thalikulam
@SIRU_Thalikulam 17 дней назад
but sir it is hiding the botton of the userform . for me it is hiding many text boxes in the bottom
@Fotoreditor-e8d
@Fotoreditor-e8d 17 дней назад
Good morning Sir! Do you have a dynamic full sale , order , stock .inventory ( tutoring detail step by step )? If have please mention me one please🙏❤
@z-4-zoon650
@z-4-zoon650 18 дней назад
Y you waste too must time to explain simple things. What you the user who try to hide excel don't about how to get macro tab. Big dislike 4 you. Next time talk to the point.
@zeweldihaile2718
@zeweldihaile2718 19 дней назад
You revealed how Microsoft Excel is powerful too in data management, data analysis, and data entry. That is more than I expected to do in Excel. Thank you for your wonderful tutorial, Sir.
@thedatalabs
@thedatalabs 18 дней назад
Thanks for your feedback!
@mostainbillah
@mostainbillah 20 дней назад
Dear sir, your video tutorial is very important for Excel learner, so a request to you, my application, Need multiple files name show when data consolidated in progress bar or status bar , could you please help me, it's very important to me, may you help me , thank you,❤
@NeelsCovers
@NeelsCovers 21 день назад
I love this but I want the database to be located on a network drive G:\, is there anyway you could write the code as everything ive tried is not working and i believe the code doesn't support this, I'm not sure. I need it for work. thank you!
@thedatalabs
@thedatalabs 20 дней назад
Thanks for your feedback! Yes, it's possible. Please watch our Multi User data entry form video available in our playlist.
@kibetkandie2495
@kibetkandie2495 22 дня назад
I have done all that you've been doing and everything that you have written, but my form is not working only showing yellow arrow at " Private Sub cmdSave_Click()"
@ArunKumar-lj5vp
@ArunKumar-lj5vp 23 дня назад
I found Creterial error kaise theek hoga
@ArunKumar-lj5vp
@ArunKumar-lj5vp 23 дня назад
shdatabase.range("A1:L" & idatabaseRow).Autofilter Field=:column, Criterial:=svalue Error is Compile error Named argument not found
@Mainulmunna
@Mainulmunna 23 дня назад
How can I get it?
@thedatalabs
@thedatalabs 20 дней назад
Download link is available in the description link. Thanks!
@nilolastimosa9621
@nilolastimosa9621 26 дней назад
How the txtID to autoincrement?
@AdibYC
@AdibYC 27 дней назад
thanks!
@AdibYC
@AdibYC 27 дней назад
A Masterpiece! THANKS
@thedatalabs
@thedatalabs 20 дней назад
Thanks for your feedback!
@AnahiValentin
@AnahiValentin 28 дней назад
what if I want it to return empty values based on my search by drop menu value?
@abhisheksingh-cd4ut
@abhisheksingh-cd4ut Месяц назад
Can you provide the search option also as we can Enter the Employee id and all data should show in the form
@rvr4295
@rvr4295 Месяц назад
Hi sir, once start time & end time captured, how to lock both the columns not to edit ?
@sandipkumarsingh2256
@sandipkumarsingh2256 Месяц назад
Thank you very much I was searching for this video since last week
@indarkumar9083
@indarkumar9083 Месяц назад
HI I am interested to buy. But this and task management can you let me know if I can use it with my company logo for my employees. I need white label is it possible?
@thedatalabs
@thedatalabs Месяц назад
Hello Indar, you can use this tool without TheDataLabs logo. Please delete the logo or replace it with your own company logo.
@tapan4253
@tapan4253 Месяц назад
i need to know how to text type in center in text box because mine text box text on top not in middle. so please let me know.
@ajulie7878
@ajulie7878 Месяц назад
That is GREAT. Thank you very much!!! One thing I would have like to know is what would be the code for the Edit button when you have a check box... Very unexperienced with VBA... Again, thank you - users will love this!
@keeleymazurkiewicz328
@keeleymazurkiewicz328 Месяц назад
I'm using Excel 2016 and there's an error regarding your code that uses EnableEvents.
@irfanshah5367
@irfanshah5367 Месяц назад
If we have not similar num col
@indarkumar9083
@indarkumar9083 Месяц назад
Nice, How to avoid duplication of entry here? Please make a video on it. it will be helpful to avoid same entry of data
@chrisder1814
@chrisder1814 Месяц назад
hello, do you know api connector? do you use AI for coding? can I find "templates" ? thanks
@kylehobley6111
@kylehobley6111 Месяц назад
Hiya, I've followed all the steps and gone back through the video multiple times, but the data in my "Form" is not being saved onto the "Database" sheet after pressing save. What might I be doing wrong?
@thedatalabs
@thedatalabs Месяц назад
Can you please share the code where you are getting an error?
@8h1n1e1e8
@8h1n1e1e8 Месяц назад
Error codes.
@thedatalabs
@thedatalabs Месяц назад
Can you share the code where you are getting an error?
@ajuvycostawailia3980
@ajuvycostawailia3980 Месяц назад
Hi sir how if we forgot password and can't open anymore..how to solve it...
@thedatalabs
@thedatalabs Месяц назад
You can open the Excel file without enabling macro and then unhide the worksheet to know the forgotten key.
@benardogega1091
@benardogega1091 Месяц назад
Hello please I can't find the support files especially the calender please help
@thedatalabs
@thedatalabs Месяц назад
The support file is already in the project. You just need to export the calendar form and import it in your project. Thanks
@chrisder1814
@chrisder1814 Месяц назад
Hello, could you help me understand if my ideas are feasible?
@ChristabelNdidi
@ChristabelNdidi Месяц назад
What a lovely video. The form works as expected, and I was even able to make some alterations here and there without compromising its integrity. I appreciate this. Thank you.
@thedatalabs
@thedatalabs Месяц назад
Thanks for your feedback!
@odishapals
@odishapals Месяц назад
If this form is shared to 100 people and they work at a time it can not work. And there is no restriction of duplicate entry. Would you like to suggest ?
@ibroraheem3854
@ibroraheem3854 Месяц назад
after this how will be lunch for public usage?
@amlan9322
@amlan9322 Месяц назад
Can it be used by multiple users at a time ?
@thedatalabs
@thedatalabs Месяц назад
Yes, it can be used. Thanks!
@karimmimoun2482
@karimmimoun2482 Месяц назад
Thanks for the video, hopefully you can help me have a question I also use an ID number linked to the order entry this is automatically generated for every new entry with the UserForm on the first sheet . When the ID is processed it is also automatically moved to the second sheet of the (closed ID) the problem is when it is moved I get the same ID number again on my first sheet do you know how I can keep this number unique? Do you have a video of this how I can keep it unique? Thanks in advance
@bandarusridevi4107
@bandarusridevi4107 Месяц назад
In the middle of the process it showing "reference isn't valid" Now what we have to do?