This has saved me an enormous amount of time. In the past I would have written macros for some of this stuff (to find "last row" to fill to bottom of a column for example) - thank you!
@Up4Excel Жыл бұрын
Great to hear this Michael 👍. I find with time I do less and less with macros as more and more Excel features are added and I discover more.
@FenderSidekick Жыл бұрын
Thanks for showing how to do this. I am a developer who often uses excel to share data with stake holders but I wanted some quicker ways to save common formulas that I can reuse on exports where the columns are the same but may be in different ordinals. One thing I ran into is that if you have an underscore in the column name, you need to add another [] pair. [@[Column_Name]] as opposed to [@ColumnName].
@Up4Excel Жыл бұрын
Good spot and thanks for sharing. I'd imagine the safest system would be to always use the extra [ ] now I think of it.
@subhraneelsaikia Жыл бұрын
greatly appreciate the explanation of finer points such as adding tbl to table name and its obvious benefits. Without using tbl,i was not able to select the table columns,even after pressing tab
@Up4Excel Жыл бұрын
Thanks for your comment Subhraneel. Sometimes it's little tips like the one about adding tbl that can make a big difference. Glad you found my video so useful 👍
@MortReany Жыл бұрын
I'm glad to find your video about this topic. Thank you so much. I was amazingly useful for me. GL.
@Up4Excel Жыл бұрын
So glad to hear that Yevhenii. Thanks for saying so 👍