MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_gIPdx4-rqGg 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
This is great! Thank you. I had a suggestion for the range section. If you want to use a whole column vs. range use the following code change: Set myTableRange = Range ("A:A, B:B, C:C, D:D"). ' You can add as many columns as you like I had a problem when I click in the cell and so not change anything, it was updating the date time. Turned out to be a user error, I had the private sub as worksheet_selectionchange, not worksheet_change. Thanks again!!
Very helpful video! Exactly what I needed. On a separate note, how can we automatically clear the dates if the data are deleted? When I delete the row of data corresponding to the dates, the dates don't disappear automatically, so I have to delete them individually. Could you make a video about this? Thank you!
lovely. that was super easy. thank you so much for explaining it in a jiffy! you solved my query and gave me a solution that i had been looking fir days!!!..what a lovely code!!
Does your course teach how to "record" a particular cell in a different book? LIke if it updates every second and I want to review what the streaming data did throughout the day-THanks
Thanks for this. Works great when entering data directly onto worksheet. When I use a form to enter data, the dates are not updating. I downloaded your example and notice it also does not update the timestamps from a data entry form. Thanks so much. :)
Hi Teach Excel - What a great method you have of putting things over. There are other good tutorials to be watched, but you can't help sensing that the tutors just hold that little thing back which is quite important. If you were not a bit savvy to be able to fill in the blanks you could easily get lost. However you applied reasoning and very good explanation. Top job.
That helped me so much getting a task done! However; is there any possible way to add more timestamps for entries to be entered in multiple columns instead of just column "E"?
Thank you for the code. Works well. Wondering how I could modify a bit, using a check box to flag that the task has been completed and once clicked I would like to load the date into a cell. Would like the macro to run once the cell has been update from the check box and the cell coming back with a "true". The cell where the true is loaded into never gets a carriage return on it
Hi D, you can do basically anything in VBA. I'd go over to our forum and ask there and upload a sample file along with the question - if you want to learn a lot more, you can always take my full VBA course here - www.teachexcel.com/vba-course-update.php?src=yt_comment_reply_gIPdx4-rqGg
Looks like i got it to work now, great code!!! thanks. One thing, how do you code it when you delete the date it deletes the input time and update time as well
thanks for the wonderful tutorial as always! I have tried the code it went successful however I was unable to delete the timestamp during wrong input, any idea to delete the row for wrong input ? looking forward to hear from you. Thanks
Hi TeachExcel, I’ve just come across this video and found it incredibly helpful, thank you for posting it. I do have 1 question. How can I add the username of the person who made the change into the next column. That way I can see who last updated the record? Thank you in advance.
Hi, great instructions! Can we modify the VBA code that it allows the user of the workbook to paste multiple rows at once, and get automatically the time stamp in the given columns for each row?
Hi Good morning Sir..would just like to ask your assistance on how I'll be able to count the events from a single cell? basically, i have a single cell that changes from "0" to "1" vice versa. (a data from PLC that is connected to excel thru (DDE ) dynamic data exchange. and I want to record how many times it changes from 0 to 1 ...thak you
How do you apply the code across multiple groups of columns each with their own reference cell to look for data entry? I have “Entry Date” & “Updated Date” in columns C & D respectively which I can get the code to work off of data entered into column B. But I also have to make this work in further column groups going across the sheet. Column A = Name of employee Column B = Status (Completed or In Progress) Column C = Date/Time populated when Column B is “Completed” Column D = Updated time whenever a change is made to Column B Then this same function has to work on the next group (Columns E,F,G,H) and so on.
Hi Teach Excel, thanks for this video, I have a question, If i have multiple values and I want to set a date change for each value respectively,i have "shipment date", "delivery date", "invoice date", and I want to know whenever the status of an order change at each step, time change will be updated in different columns for sure, Thank you!!
Awesome work man, thanks a lot, i don't know any of this programs or coding and i made it work for a specific job, plus english is not my first language
How to add input time in large data set.... Like is there any formula which we can apply for input time and then excel will fill the entire column of "INPUT TIME"
How can I integrate this into my excel form that inputs data via a Form? Seems like the macro doesn't view data entered via form the same as data entered directly into the cell.
Hey thanks for describing the code. I am new to Macro and have a quick question. After using this code I am unable to delete rows manually. I am unable to delete a row when it has those two columns populated with dates. Can anyone help me in this regard? Thanks in advance.
Hi there, your video is very useful. I need your help on how to use these codes twice in a sheet. For me I need a three columns as TableRange, InputTime, UpdatedTime and another TableRange, InputTime, UpdatedTime. I tried and get Compile error ambiguous named
Definitely you can - it depends how you want to store the usrename, but its easy to do - ask in our forum and include a sample file and it should be easy to help) www.teachexcel.com/talk/microsoft-office?src=yt_comment
Muito obrigado, trabalhar com excel é liberdade e muita economia de tempo. Estou tentando converter o Timestamp na api da Binance para esse formato Excel e ainda tenho que converter no formato brasileiro.
What if we want to stamp auto date and time on top of the column? Data rage A5:D10 and Row1 and Row2 of each column for the time and updated time. Thanks
Thank you! I'm glad you think so :) And if you need any help with this guy, feel free to ask on our forum, a lot of people tend to want to customize this one. www.teachexcel.com/talk/microsoft-office?src=yt_comment
Could you update the code for a scenario where the range is formatted as a table. In case I add new columns before the date columns in the future so I do not have to update the code?
Thanks, it worked for a while but now it has stopped after I protected the sheet, and now it doesn't work anymore even without the protection. What can I do to solve this? thanks
Thanks) Unlock all cells but the Dat column and then protect the sheet and have the macro unprotect the sheet, input the timestamp, and reprotect the sheet. If you want more specific help with code examples, ask in our forum and it is much much easier to help: www.teachexcel.com/talk/microsoft-office?src=yt_comment
Awesome tutorial, I receive a Run-time error 91 Object Variable or With block variable not set when modifying a value in my table, any idea how to fix this? I use office 2019. thanks!
Andor, shoot the code into our forum and ask your question there - or upload a sample file. Then it will be easy to test it out. It is for sure a small issue.
great tutorial i have an issue with the code i want to let the updated time only get triggered by one new colume instead of it being triggered by the first time colume how do i do that
This is just good and a rare example. However I want to trigger change event when the cell value is deleted the corresponding datestamp must delete. Is it possible?
basically, everything is possible - give it a try and post your work on our forum and it should be easy to help :) www.teachexcel.com/talk/microsoft-office?src=yt_comment
'I wanted to put the timestamps in another worksheet named data, like this; Set myDateTimeRange = Worksheets("data").Range("Y" & Target.Row), but it yellowed out on me. What did I do wrong?
Really great tutorial! Thank you so much! In my spreadsheet each client has a row with various data in each cell. I have unique notes entered in all cells in column D about the respective client. How can I get the timestamp to update when I only change a note on the cell but not necessarily the cell value? Timestamp updates when I change the cell value but not when I change the note. Any counsel is much appreciated.
Hi, this is not the best venue for helping, go ahead and ask in our forum, along with any sample code you have, and it should be easy to help) www.teachexcel.com/talk/microsoft-office?src=yt_comment
Hey thank you for the video it was really helpful. It works perfectly when single cell is added/updated but when someone takes a data dump, only the first cells are updated. Any changes in code which could help in adding timestamp in all the cells at once?
I want to lock cells in a row after entering the data in the cells in that row by selecting a yes or no from a drop down list at the end of that row. "is the data in this row complete?" yes = locked row. Can someone please help.
Right-click the cell and change the cell formatting for the cells before the timestamp is input and see if that helps. There are other ways but this is the easiest solution usually. If that doesn't work, ask in our forum and we can find a better solution, probably with a little code. www.teachexcel.com/talk/microsoft-office?src=yt
Depends how the process is started and ended in Excel. Ask this question in our forum and include more info, even uploading a sample file, and it will be easier to help you. www.teachexcel.com/talk/microsoft-office?src=yt
You're gonna have to upload the file that you're using to our forum to get specific help with this issue - I'm sure it's something small but I can't debug it from here. www.teachexcel.com/talk/microsoft-office?src=yt_comment
Well sure there are lots of formatting options. If you upload a sample file on our forum and ask there, I can give you a more specific answer to your issue based on your data set. www.teachexcel.com/talk/microsoft-office?src=yt Otherwise, just click the iten in the Value section > Value Field Settings > Number Format
Do you mean within the excel file? Because the link to the page with the file is at the top of the description and the file is on the top-right of the linked page under where it says Tutorial Details. In the video, around 18 seconds in, it shows you how to get it.
You might want to store it in a personal macro workbook so it will be there for all workbooks to access. Here is a tutorial I did that explains that process: ruclips.net/video/VvZMuPMY4C4/видео.html
This is just great. I have one question: How to do the macro, that clumn A gets the original (or input) date and time (in column E), but columns B, C, D get the date and time whet data is entered and the date and time is shown in columns F, G, H? So basically how to do the macro that every column (from A to D) gets the date and time separately upon data input. Column A (data input), column E (time stamp). Column B (data input), column F (time stamp). Column C (data input), column G (time stamp). Column D (data input), column H (time stamp). I don't need updated time. Thank you for your anwser.
Go to second 0:22 in this video and you will see a big red box around the part of the page where you download the file. It is in a grey box that says "Tutorial Details" on the top and has a line that says "Downloadable Files" in it and next to that is a link titled "Excel File."
Yea sure, just ask your question on our forum and be specific about what you are trying to do and upload a sample excel file to illustrate the issue. It's much easier to help there than through comments here lol TeachExcel Forum: www.teachexcel.com/talk/microsoft-office?src=yt
Not really sure what you mean, sorry. If you can provide more details or a sample file, feel free to ask on our forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment
MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_gIPdx4-rqGg
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
One of the best macros application, code scope explanation, and neat development tutorial!
Thank you so much! I have been searching for a solution to a static date/time stamp for several months. This tutorial finally gave me an answer.
Right click on the timestamp template tab at the bottom of the downloaded worksheet.
Click on View Code, select all and then paste into macro.
This is great! Thank you. I had a suggestion for the range section.
If you want to use a whole column vs. range use the following code change:
Set myTableRange = Range ("A:A, B:B, C:C, D:D"). ' You can add as many columns as you like
I had a problem when I click in the cell and so not change anything, it was updating the date time. Turned out to be a user error, I had the private sub as worksheet_selectionchange, not worksheet_change.
Thanks again!!
is it possible if we set the code on a table type in excel? I have a habit in using table more than normal ranges
An excellently produced and delivered tutorial for a 'newbe' learning macos - Thanks!
You're welcome! Glad you liked it! :)
@@TeachExcel I've been wanting to do this for YEARS! I've looked all over to do this and couldn't find it. THANK YOU!!
Great tutorial, how would I build on this code to include multiple time stamps for additional non-sequential columns?
Very helpful video! Exactly what I needed. On a separate note, how can we automatically clear the dates if the data are deleted? When I delete the row of data corresponding to the dates, the dates don't disappear automatically, so I have to delete them individually. Could you make a video about this? Thank you!
Thank you - that was just what i was looking for
lovely. that was super easy. thank you so much for explaining it in a jiffy! you solved my query and gave me a solution that i had been looking fir days!!!..what a lovely code!!
Does your course teach how to "record" a particular cell in a different book? LIke if it updates every second and I want to review what the streaming data did throughout the day-THanks
Thanks for this. Works great when entering data directly onto worksheet. When I use a form to enter data, the dates are not updating. I downloaded your example and notice it also does not update the timestamps from a data entry form. Thanks so much. :)
Hi Teach Excel - What a great method you have of putting things over. There are other good tutorials to be watched, but you can't help sensing that the tutors just hold that little thing back which is quite important. If you were not a bit savvy to be able to fill in the blanks you could easily get lost. However you applied reasoning and very good explanation. Top job.
Thank you very much for your nice comment! I'm very happy that you found my explanation good and useful and I hope I can keep it up :))
That helped me so much getting a task done! However; is there any possible way to add more timestamps for entries to be entered in multiple columns instead of just column "E"?
Did you ever figure this out because I need it too!
Great video broo, and can you explain to me why when this macro turned on the undo option (ctrl+z) is not working
Thank you for the code. Works well. Wondering how I could modify a bit, using a check box to flag that the task has been completed and once clicked I would like to load the date into a cell. Would like the macro to run once the cell has been update from the check box and the cell coming back with a "true". The cell where the true is loaded into never gets a carriage return on it
Hi D, you can do basically anything in VBA. I'd go over to our forum and ask there and upload a sample file along with the question - if you want to learn a lot more, you can always take my full VBA course here - www.teachexcel.com/vba-course-update.php?src=yt_comment_reply_gIPdx4-rqGg
Looks like i got it to work now, great code!!! thanks. One thing, how do you code it when you delete the date it deletes the input time and update time as well
thanks for the wonderful tutorial as always! I have tried the code it went successful however I was unable to delete the timestamp during wrong input, any idea to delete the row for wrong input ? looking forward to hear from you. Thanks
Hi TeachExcel, I’ve just come across this video and found it incredibly helpful, thank you for posting it.
I do have 1 question. How can I add the username of the person who made the change into the next column. That way I can see who last updated the record?
Thank you in advance.
How do you create a macro to compared a set of time to a real time and the do a copy and paste of row of cell to another row of cell ?
Great video-Do you know how to record the streaming data into a log for future review? Can you create graphs from it?
If I wanted to lock the cells that have the time stamp how do I limit it to only "F1" or "G2" and not have it moving on down the column or worksheet?
Thanks alot as you just saved me alot of time and a big headache
Thanks nice one. Is there any option to use same coding for multiple data table in single excel sheet. Please advise.
Hi, great instructions! Can we modify the VBA code that it allows the user of the workbook to paste multiple rows at once, and get automatically the time stamp in the given columns for each row?
Pls make a detail video on how to plot Live data in graphical form.. for example- time vs change in OI. THANK YOU
Thanks. Can you define as a table name instead of table range?
Great tutorial, very informative. In case this is shared with others to enter data, can we have an extra column showing who did the last entry?
I ALSO WANT THE LAST COLUMN TO SHOW WHO DID THE LAST ENTRY. DID YOU FIND THE ANSWER?
Hi Good morning Sir..would just like to ask your assistance on how I'll be able to count the events from a single cell?
basically, i have a single cell that changes from "0" to "1" vice versa. (a data from PLC that is connected to excel thru (DDE ) dynamic data exchange. and I want to record how many times it changes from 0 to 1 ...thak you
Thank you so much for explaining how it works!
How do you apply the code across multiple groups of columns each with their own reference cell to look for data entry?
I have “Entry Date” & “Updated Date” in columns C & D respectively which I can get the code to work off of data entered into column B. But I also have to make this work in further column groups going across the sheet.
Column A = Name of employee
Column B = Status (Completed or In Progress)
Column C = Date/Time populated when Column B is “Completed”
Column D = Updated time whenever a change is made to Column B
Then this same function has to work on
the next group (Columns E,F,G,H) and so on.
Hi Teach Excel, thanks for this video, I have a question, If i have multiple values and I want to set a date change for each value respectively,i have "shipment date", "delivery date", "invoice date", and I want to know whenever the status of an order change at each step, time change will be updated in different columns for sure,
Thank you!!
Awesome work man, thanks a lot, i don't know any of this programs or coding and i made it work for a specific job, plus english is not my first language
How to add input time in large data set.... Like is there any formula which we can apply for input time and then excel will fill the entire column of "INPUT TIME"
How can I integrate this into my excel form that inputs data via a Form? Seems like the macro doesn't view data entered via form the same as data entered directly into the cell.
Hi, how to apply the Auto Timestamp to different targets/ Columns?
Hey thanks for describing the code. I am new to Macro and have a quick question. After using this code I am unable to delete rows manually. I am unable to delete a row when it has those two columns populated with dates. Can anyone help me in this regard? Thanks in advance.
Hi there, your video is very useful. I need your help on how to use these codes twice in a sheet. For me I need a three columns as TableRange, InputTime, UpdatedTime and another TableRange, InputTime, UpdatedTime. I tried and get Compile error ambiguous named
Hi, thank you for the wonderful tutorial, could you pls clarify if we can also automate to capture the username who has edited or updated the cells.
Definitely you can - it depends how you want to store the usrename, but its easy to do - ask in our forum and include a sample file and it should be easy to help) www.teachexcel.com/talk/microsoft-office?src=yt_comment
What if range is the whole workbook, and I only want to display the updated date/time in one cell?
Can you do this on excel table ! I tried but it didn’t work.
Muito obrigado, trabalhar com excel é liberdade e muita economia de tempo. Estou tentando converter o Timestamp na api da Binance para esse formato Excel e ainda tenho que converter no formato brasileiro.
What if we want to stamp auto date and time on top of the column?
Data rage A5:D10 and Row1 and Row2 of each column for the time and updated time.
Thanks
Very clear explanation.Thanks
Excellent work
Simple ....... easy
Thank you! I'm glad you think so :) And if you need any help with this guy, feel free to ask on our forum, a lot of people tend to want to customize this one. www.teachexcel.com/talk/microsoft-office?src=yt_comment
Could you update the code for a scenario where the range is formatted as a table. In case I add new columns before the date columns in the future so I do not have to update the code?
I mad a data entry form with macro from another youtube tutorial, but there is no timestamp option. Is there a way we can add the time stamp feature?
Is there anyway to automatically timestamp data entries in Excel Online? (Excel viewed in SharePoint, MS Teams, OneDrive etc.)? Thank you!
Thanks, it worked for a while but now it has stopped after I protected the sheet, and now it doesn't work anymore even without the protection. What can I do to solve this? thanks
Thanks for sharing the same.
But, Undo (Ctrl+Z) is not working on this method....
Hey first of all awesome tutorial!
Is there a way to lock the dat column?
Thanks) Unlock all cells but the Dat column and then protect the sheet and have the macro unprotect the sheet, input the timestamp, and reprotect the sheet. If you want more specific help with code examples, ask in our forum and it is much much easier to help: www.teachexcel.com/talk/microsoft-office?src=yt_comment
when i lock certain column, the time staps doesnt work, i get something like debug, any help here
Excellent work my friend! Many thanks. A request if I may would be whether or not we can do the same with google sheets?
I have no idea.
Awesome tutorial, I receive a Run-time error 91 Object Variable or With block variable not set when modifying a value in my table, any idea how to fix this? I use office 2019. thanks!
Andor, shoot the code into our forum and ask your question there - or upload a sample file. Then it will be easy to test it out. It is for sure a small issue.
great tutorial i have an issue with the code i want to let the updated time only get triggered by one new colume instead of it being triggered by the first time colume how do i do that
This is just good and a rare example.
However I want to trigger change event when the cell value is deleted the corresponding datestamp must delete. Is it possible?
basically, everything is possible - give it a try and post your work on our forum and it should be easy to help :) www.teachexcel.com/talk/microsoft-office?src=yt_comment
'I wanted to put the timestamps in another worksheet named data, like this; Set myDateTimeRange = Worksheets("data").Range("Y" & Target.Row), but it yellowed out on me. What did I do wrong?
yes, I should Subscribe. Explained In a Great Way!
Thankyou
Thanks for this Awesome Video and I've already subscribed to your wonderful channel. Would you please share a link of the Macro file. Thanks.
Really great tutorial! Thank you so much! In my spreadsheet each client has a row with various data in each cell. I have unique notes entered in all cells in column D about the respective client. How can I get the timestamp to update when I only change a note on the cell but not necessarily the cell value? Timestamp updates when I change the cell value but not when I change the note. Any counsel is much appreciated.
Hi, this is not the best venue for helping, go ahead and ask in our forum, along with any sample code you have, and it should be easy to help) www.teachexcel.com/talk/microsoft-office?src=yt_comment
Hey thank you for the video it was really helpful. It works perfectly when single cell is added/updated but when someone takes a data dump, only the first cells are updated. Any changes in code which could help in adding timestamp in all the cells at once?
צת .תמ ננ מ מנמ מ !צ מ! מ
I want to lock cells in a row after entering the data in the cells in that row by selecting a yes or no from a drop down list at the end of that row. "is the data in this row complete?" yes = locked row. Can someone please help.
Thanks for the tutorial. It's not working for my excel workbook though.
I can't help you if you don't describe the issue - or go to the forum on teachexcel.com and upload a sample file with an explanation of the issue.
How do i run this in the same sheet for multiple cells?
The code is really good, Thankyou. But the time stamp doest change when the value is updated through the formula.
I have completed a file few month ago and now suddenly I need to know when did I do the last change. Can I find that past time?
Hi, where do I go to download the formula? Can you please assist with this?
Hi is it possible to include seconds in timestamp? Newbie here
wow, this is what I was looking for. Greatr job, thanks! :)
Hi thank you but how can i get the copy code? pls
What if I want the last updated date and time to appear in one cell only?
Hi, thank you this works perfectly on the day but the code disappears the next day, how can i save it?
What if I want the time stamp on the left of the data entry?
You’re a star mate!
I have signed in and out many times but I can't download the training file. Anyone can just share the VBA code please?
can i ask question? i used excel 2010 but it doesn't work. what would i do. thank in advance. (phillipines)
Great macro m8, is it any chance that only will show me the time only without date? Was trying custom formating but always shows date, mega thx
Right-click the cell and change the cell formatting for the cells before the timestamp is input and see if that helps. There are other ways but this is the easiest solution usually. If that doesn't work, ask in our forum and we can find a better solution, probably with a little code. www.teachexcel.com/talk/microsoft-office?src=yt
How do I download the workbook so that I can get the formula?
How can i make two time stamps for example time when certain process started and then time when ended? Thx u very much this is so awesome :)
Depends how the process is started and ended in Excel. Ask this question in our forum and include more info, even uploading a sample file, and it will be easier to help you. www.teachexcel.com/talk/microsoft-office?src=yt
Great instructions!!!
It is not working as my tablerange is formulated.. is there any other method for that?
I followed everything as is but when entered data on Column A then Tab, nothing appears on column E and F for the date.
Please help.
You're gonna have to upload the file that you're using to our forum to get specific help with this issue - I'm sure it's something small but I can't debug it from here.
www.teachexcel.com/talk/microsoft-office?src=yt_comment
I have downloaded the file and wrote thing in the range defined and nothing happens.
I found the Excel document "Automatically Timestamp Entries in Excel", but where is the Macro coding?
Should be in Sheet 1 - you could right click the sheet tab and click View Code and that should also take you there.
after pressing 'alt 11' the page that opens does not show a sheet to select
than you this is so amazing! it works perfectly
Very good and simple the video!!! Congratulations!!!
Thank you so much! Glad you liked it :) Let me know if you have any thoughts for future tutorials!
awesome tutorial! Thanks
hi there. i want amount in Lac on my Pivot Table is there any number formatting ??? Plz Help
Well sure there are lots of formatting options. If you upload a sample file on our forum and ask there, I can give you a more specific answer to your issue based on your data set. www.teachexcel.com/talk/microsoft-office?src=yt Otherwise, just click the iten in the Value section > Value Field Settings > Number Format
thanks for reply i uploaded my sample file
error 424!, "object required",
please tell what to do ??
How to sort, Filter Data With dates when it includes time stamp
As Paul asked below, where do I find the macro file?
Do you mean within the excel file? Because the link to the page with the file is at the top of the description and the file is on the top-right of the linked page under where it says Tutorial Details. In the video, around 18 seconds in, it shows you how to get it.
@@TeachExcel Same question. I found the Excel document "Automatically Timestamp Entries in Excel", but where is the Macro coding?
Problem is that I'm using pivot tables and once I've captured data in any column before F, I can't remove it
I tried this in Office 365 Excel and does not work... it does not display the date not the updated date
Thanks for the video, but the code disappears Everytime I restart my PC . How do I permanently save it
You might want to store it in a personal macro workbook so it will be there for all workbooks to access. Here is a tutorial I did that explains that process: ruclips.net/video/VvZMuPMY4C4/видео.html
This is just great.
I have one question:
How to do the macro, that clumn A gets the original (or input) date and time (in column E), but columns B, C, D get the date and time whet data is entered and the date and time is shown in columns F, G, H?
So basically how to do the macro that every column (from A to D) gets the date and time separately upon data input.
Column A (data input), column E (time stamp).
Column B (data input), column F (time stamp).
Column C (data input), column G (time stamp).
Column D (data input), column H (time stamp).
I don't need updated time.
Thank you for your anwser.
Thanks, really great!
Where do I find the macro file?
The first link in the description. At about 17 seconds into the video, you see where to find the link and the download file.
There is nothing in the "Placeholder for file" Is this where you download the macro file?
Go to second 0:22 in this video and you will see a big red box around the part of the page where you download the file. It is in a grey box that says "Tutorial Details" on the top and has a line that says "Downloadable Files" in it and next to that is a link titled "Excel File."
Welcome back
Thanks! :)
Explained so simply ✌🏼👍🏻 Thanks buddy ✌🏻
You're very welcome! Glad you liked it :)
I need vba macro for Trim and cleaning data. Could you help for this.
Yea sure, just ask your question on our forum and be specific about what you are trying to do and upload a sample excel file to illustrate the issue. It's much easier to help there than through comments here lol
TeachExcel Forum: www.teachexcel.com/talk/microsoft-office?src=yt
Hi, I am getting an runtime error " Run-time error '-2147417848 (80010108)':" How can I fix this. But overall the video is really helpful
how to find percentage of live data updation?
Not really sure what you mean, sorry. If you can provide more details or a sample file, feel free to ask on our forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment