Automatically Timestamp Data Entries in Excel

Поделиться
HTML-код
  • Опубликовано: 16 дек 2024

Комментарии • 160

  • @TeachExcel
    @TeachExcel  2 года назад

    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

  • @ferchofarias6635
    @ferchofarias6635 3 года назад +1

    One of the best macros application, code scope explanation, and neat development tutorial!

  • @janellegriego6962
    @janellegriego6962 2 года назад

    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.

  • @trelzy73
    @trelzy73 5 лет назад +3

    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.

  • @mikes4830
    @mikes4830 5 лет назад +5

    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!!

    • @NhungNguyen-ho5op
      @NhungNguyen-ho5op Год назад

      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

  • @AndrewSmith-vv7vh
    @AndrewSmith-vv7vh 6 лет назад +1

    An excellently produced and delivered tutorial for a 'newbe' learning macos - Thanks!

    • @TeachExcel
      @TeachExcel  6 лет назад +1

      You're welcome! Glad you liked it! :)

    • @53KJB
      @53KJB 4 года назад

      @@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!!

  • @richardbannister5172
    @richardbannister5172 4 года назад +2

    Great tutorial, how would I build on this code to include multiple time stamps for additional non-sequential columns?

  • @justinemiano4701
    @justinemiano4701 6 месяцев назад

    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!

  • @craigwoodward7677
    @craigwoodward7677 4 месяца назад

    Thank you - that was just what i was looking for

  • @umairhanfi
    @umairhanfi Год назад

    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!!

  • @JD-ks2nv
    @JD-ks2nv 2 года назад

    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

  • @janjosey5642
    @janjosey5642 3 года назад

    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. :)

  • @jonpye444
    @jonpye444 4 года назад

    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.

    • @TeachExcel
      @TeachExcel  4 года назад +1

      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 :))

  • @AyaGeee808
    @AyaGeee808 2 года назад +1

    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"?

    • @Talon73
      @Talon73 Год назад

      Did you ever figure this out because I need it too!

  • @Shirosh_ft._Stephen
    @Shirosh_ft._Stephen Год назад

    Great video broo, and can you explain to me why when this macro turned on the undo option (ctrl+z) is not working

  • @TheBus1974
    @TheBus1974 2 года назад

    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

    • @TeachExcel
      @TeachExcel  2 года назад

      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

  • @1128roel
    @1128roel 4 года назад

    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

  • @leejinghao6941
    @leejinghao6941 2 года назад

    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

  • @Chris-eq2vk
    @Chris-eq2vk 2 года назад

    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.

  • @roddizon2242
    @roddizon2242 3 года назад

    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 ?

  • @JD-ks2nv
    @JD-ks2nv 2 года назад

    Great video-Do you know how to record the streaming data into a log for future review? Can you create graphs from it?

  • @TheStevo1712
    @TheStevo1712 Месяц назад

    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?

  • @Riverdon-c7r
    @Riverdon-c7r 5 месяцев назад

    Thanks alot as you just saved me alot of time and a big headache

  • @nitilanchan7787
    @nitilanchan7787 3 года назад

    Thanks nice one. Is there any option to use same coding for multiple data table in single excel sheet. Please advise.

  • @erikengels9613
    @erikengels9613 4 года назад

    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?

  • @monporoshneog4725
    @monporoshneog4725 3 года назад

    Pls make a detail video on how to plot Live data in graphical form.. for example- time vs change in OI. THANK YOU

  • @stanTrX
    @stanTrX 2 года назад

    Thanks. Can you define as a table name instead of table range?

  • @TP014563
    @TP014563 3 года назад +1

    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?

    • @fluffyhoneytina
      @fluffyhoneytina 2 года назад

      I ALSO WANT THE LAST COLUMN TO SHOW WHO DID THE LAST ENTRY. DID YOU FIND THE ANSWER?

  • @rey.vasquez4365
    @rey.vasquez4365 Год назад

    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

  • @matthewmusselwhite591
    @matthewmusselwhite591 3 года назад

    Thank you so much for explaining how it works!

  • @dcsmooth
    @dcsmooth 2 года назад

    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.

  • @Freemachains
    @Freemachains 2 года назад

    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!!

  • @eduardocabuya9847
    @eduardocabuya9847 2 года назад

    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

  • @thatdataguy3429
    @thatdataguy3429 2 года назад

    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"

  • @zachoxley
    @zachoxley Год назад

    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.

  • @JeffMartinez-dp9pd
    @JeffMartinez-dp9pd 2 года назад

    Hi, how to apply the Auto Timestamp to different targets/ Columns?

  • @muhammadwaqasjaved9470
    @muhammadwaqasjaved9470 4 года назад

    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.

  • @SURYAVASU
    @SURYAVASU 4 года назад

    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

  • @vijaykumarchoukimath2924
    @vijaykumarchoukimath2924 4 года назад

    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.

    • @TeachExcel
      @TeachExcel  4 года назад

      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

  • @user-hn9mt8ti3o
    @user-hn9mt8ti3o Год назад

    What if range is the whole workbook, and I only want to display the updated date/time in one cell?

  • @ranjeethrikkala6344
    @ranjeethrikkala6344 3 года назад +1

    Can you do this on excel table ! I tried but it didn’t work.

  • @negociosonline40
    @negociosonline40 3 года назад

    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.

  • @elyarsaeedi4264
    @elyarsaeedi4264 4 года назад

    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

  • @sudarapremathilaka1706
    @sudarapremathilaka1706 3 года назад

    Very clear explanation.Thanks

  • @ShakeebVakkom
    @ShakeebVakkom 4 года назад

    Excellent work
    Simple ....... easy

    • @TeachExcel
      @TeachExcel  4 года назад

      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

  • @JamesClarke1
    @JamesClarke1 4 года назад

    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?

  • @tristanjimenez87
    @tristanjimenez87 5 лет назад

    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?

  • @shayestegall6571
    @shayestegall6571 3 года назад

    Is there anyway to automatically timestamp data entries in Excel Online? (Excel viewed in SharePoint, MS Teams, OneDrive etc.)? Thank you!

  • @samanzuca
    @samanzuca Год назад

    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

  • @AshokYadav-mf2rm
    @AshokYadav-mf2rm 4 года назад

    Thanks for sharing the same.
    But, Undo (Ctrl+Z) is not working on this method....

  • @Chainer-he5zr
    @Chainer-he5zr 4 года назад

    Hey first of all awesome tutorial!
    Is there a way to lock the dat column?

    • @TeachExcel
      @TeachExcel  4 года назад +1

      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

    • @Barchafel
      @Barchafel 4 года назад +1

      when i lock certain column, the time staps doesnt work, i get something like debug, any help here

  • @TheStrossicro
    @TheStrossicro 5 лет назад

    Excellent work my friend! Many thanks. A request if I may would be whether or not we can do the same with google sheets?

  • @andorandor5462
    @andorandor5462 4 года назад

    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!

    • @TeachExcel
      @TeachExcel  4 года назад

      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.

  • @abestech7190
    @abestech7190 4 года назад

    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

  • @rakshitharamesh3161
    @rakshitharamesh3161 4 года назад

    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?

    • @TeachExcel
      @TeachExcel  4 года назад +1

      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

  • @yvindGranberg
    @yvindGranberg 5 лет назад

    '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?

  • @mrarshidbhat
    @mrarshidbhat 5 лет назад +1

    yes, I should Subscribe. Explained In a Great Way!
    Thankyou

  • @knowhow1242
    @knowhow1242 4 года назад

    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.

  • @bighaasfly
    @bighaasfly 4 года назад

    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.

    • @TeachExcel
      @TeachExcel  4 года назад

      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

  • @keyurs3822
    @keyurs3822 4 года назад

    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?

  • @jordanemery7069
    @jordanemery7069 3 года назад

    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.

  • @AmeliaBaljit
    @AmeliaBaljit 5 лет назад +1

    Thanks for the tutorial. It's not working for my excel workbook though.

    • @TeachExcel
      @TeachExcel  5 лет назад

      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.

  • @HomeMovieEmpire
    @HomeMovieEmpire Год назад

    How do i run this in the same sheet for multiple cells?

  • @mohdmuzu142
    @mohdmuzu142 4 года назад

    The code is really good, Thankyou. But the time stamp doest change when the value is updated through the formula.

  • @Sayeef_Khan
    @Sayeef_Khan 4 года назад

    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?

  • @valmirberisha5232
    @valmirberisha5232 4 года назад

    Hi, where do I go to download the formula? Can you please assist with this?

  • @jincasino594
    @jincasino594 3 года назад

    Hi is it possible to include seconds in timestamp? Newbie here

  • @laszlobogdan4450
    @laszlobogdan4450 4 года назад

    wow, this is what I was looking for. Greatr job, thanks! :)

  • @wilainaja
    @wilainaja 4 года назад

    Hi thank you but how can i get the copy code? pls

  • @dyiphotography8076
    @dyiphotography8076 Год назад

    What if I want the last updated date and time to appear in one cell only?

  • @Rachelt78
    @Rachelt78 4 года назад

    Hi, thank you this works perfectly on the day but the code disappears the next day, how can i save it?

  • @ninabrillantes652
    @ninabrillantes652 Год назад

    What if I want the time stamp on the left of the data entry?

  • @dranelleonardoful
    @dranelleonardoful 4 года назад

    You’re a star mate!

  • @mikelennon1078
    @mikelennon1078 2 года назад

    I have signed in and out many times but I can't download the training file. Anyone can just share the VBA code please?

  • @eugenedating745
    @eugenedating745 6 лет назад

    can i ask question? i used excel 2010 but it doesn't work. what would i do. thank in advance. (phillipines)

  • @HITOKIRIpl
    @HITOKIRIpl 5 лет назад

    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

    • @TeachExcel
      @TeachExcel  5 лет назад

      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

  • @valmirberisha5232
    @valmirberisha5232 4 года назад

    How do I download the workbook so that I can get the formula?

  • @lazarsavic9958
    @lazarsavic9958 5 лет назад

    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 :)

    • @TeachExcel
      @TeachExcel  5 лет назад

      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

  • @christycox4129
    @christycox4129 2 года назад

    Great instructions!!!

  • @abbbbbbbbi
    @abbbbbbbbi 10 месяцев назад

    It is not working as my tablerange is formulated.. is there any other method for that?

  • @oldcode314
    @oldcode314 3 года назад

    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.

    • @TeachExcel
      @TeachExcel  3 года назад

      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

  • @Linkonem
    @Linkonem 4 года назад

    I have downloaded the file and wrote thing in the range defined and nothing happens.

  • @InstructorDePoy
    @InstructorDePoy 4 года назад

    I found the Excel document "Automatically Timestamp Entries in Excel", but where is the Macro coding?

    • @TeachExcel
      @TeachExcel  4 года назад

      Should be in Sheet 1 - you could right click the sheet tab and click View Code and that should also take you there.

  • @andywintx
    @andywintx Год назад

    after pressing 'alt 11' the page that opens does not show a sheet to select

  • @Hans_Olo
    @Hans_Olo 11 месяцев назад

    than you this is so amazing! it works perfectly

  • @pauloa.2026
    @pauloa.2026 6 лет назад

    Very good and simple the video!!! Congratulations!!!

    • @TeachExcel
      @TeachExcel  6 лет назад

      Thank you so much! Glad you liked it :) Let me know if you have any thoughts for future tutorials!

  • @titantts
    @titantts 3 года назад

    awesome tutorial! Thanks

  • @suddushetty
    @suddushetty 6 лет назад

    hi there. i want amount in Lac on my Pivot Table is there any number formatting ??? Plz Help

    • @TeachExcel
      @TeachExcel  6 лет назад

      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

    • @suddushetty
      @suddushetty 6 лет назад

      thanks for reply i uploaded my sample file

  • @deepanderneopaney7990
    @deepanderneopaney7990 2 года назад

    error 424!, "object required",
    please tell what to do ??

  • @indiananimesenpai1566
    @indiananimesenpai1566 3 года назад

    How to sort, Filter Data With dates when it includes time stamp

  • @robertstark396
    @robertstark396 6 лет назад

    As Paul asked below, where do I find the macro file?

    • @TeachExcel
      @TeachExcel  6 лет назад +1

      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.

    • @InstructorDePoy
      @InstructorDePoy 4 года назад

      @@TeachExcel Same question. I found the Excel document "Automatically Timestamp Entries in Excel", but where is the Macro coding?

  • @thatotlakedi5694
    @thatotlakedi5694 3 года назад

    Problem is that I'm using pivot tables and once I've captured data in any column before F, I can't remove it

  • @1128roel
    @1128roel 4 года назад

    I tried this in Office 365 Excel and does not work... it does not display the date not the updated date

  • @martintavengwa654
    @martintavengwa654 4 года назад

    Thanks for the video, but the code disappears Everytime I restart my PC . How do I permanently save it

    • @TeachExcel
      @TeachExcel  4 года назад

      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

  • @aleksanderdvanajscak3472
    @aleksanderdvanajscak3472 4 года назад

    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.

  • @crisbenmarkduque8056
    @crisbenmarkduque8056 3 года назад

    Thanks, really great!

  • @luapgluapg
    @luapgluapg 6 лет назад +1

    Where do I find the macro file?

    • @TeachExcel
      @TeachExcel  6 лет назад

      The first link in the description. At about 17 seconds into the video, you see where to find the link and the download file.

    • @luapgluapg
      @luapgluapg 6 лет назад

      There is nothing in the "Placeholder for file" Is this where you download the macro file?

    • @TeachExcel
      @TeachExcel  6 лет назад

      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."

    • @DeepakChauhan-mn5jw
      @DeepakChauhan-mn5jw 6 лет назад

      Welcome back

    • @TeachExcel
      @TeachExcel  6 лет назад

      Thanks! :)

  • @mickoo07
    @mickoo07 6 лет назад

    Explained so simply ✌🏼👍🏻 Thanks buddy ✌🏻

    • @TeachExcel
      @TeachExcel  6 лет назад +1

      You're very welcome! Glad you liked it :)

    • @mickoo07
      @mickoo07 6 лет назад

      I need vba macro for Trim and cleaning data. Could you help for this.

    • @TeachExcel
      @TeachExcel  6 лет назад +1

      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

  • @mainesherbas
    @mainesherbas 4 года назад

    Hi, I am getting an runtime error " Run-time error '-2147417848 (80010108)':" How can I fix this. But overall the video is really helpful

  • @naturearts9663
    @naturearts9663 4 года назад

    how to find percentage of live data updation?

    • @TeachExcel
      @TeachExcel  4 года назад +1

      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