hi.. if i like to create date on every new row the is created in the table. im using NOW(). how can i prevent it from updating every row? i just want it to run the NOW() once.
I have made a Table roughly the same as yours, why am I getting why am I getting this =Table1[[#This Row],[Sales]] and not =[@Sales]? In fact, I manually typed in =[@Sales]-[@COGS] it is giving me an error? I am using Excel 2007
The best Excel Table presentation on YT and i've watched all there is. Thanks !
Very interesting Topic. Tks a lot
Where can I find the files used in this video to practice?
Have you attached those in some other video?
Thanks a lot, you saved good amount of effort
Great to hear!
All your videos are good. Can you teach us how we can make expandable table in google sheets like we have in excel??
Unfortunately, there is no such thing in sheets. Just regular ranges.
Great videos. Time to start using XLOOKUP function?
not a big fan of xlookup so far.
hi.. if i like to create date on every new row the is created in the table. im using NOW(). how can i prevent it from updating every row? i just want it to run the NOW() once.
I have made a Table roughly the same as yours, why am I getting why am I getting this =Table1[[#This Row],[Sales]] and not =[@Sales]? In fact, I manually typed in =[@Sales]-[@COGS] it is giving me an error? I am using Excel 2007
Would you mind showing how to make login form? I have watched userform on this channel, but it didn't show how if we enter login form.
Thanks
Thank you sm
👍
Very interesting. Nice to know. But in my opinion this is much easier in ms access.
11/14/2023 ~7:46
Sir I have shared folder to other person & upload screenshot image do the work & how to lock & stop he is update image on next day with manage version
Does this work with pivot tables?
Yes.
How can we convert hundred of small tables sitting in one sheet in an easy way instead of converting each table individually.
You would need to write a macro.
Hello everyone. Can anyone please help me to add a formula into my Excel table header?