Hi and thanks, yes you can use LastColumn within your VBA Code to accommodate the dynamic column numbers. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks for your kind words. My AI Toolkit should be able to handle that conversion here bit.ly/AIToolpack_RandyShared I hope this helps and thanks so much.
Thatnks for your great video leatning. i have a question. When you create your projects (invoices, sales ....etc) you do not use the table in your BDD for storing data, but y use the static classic tables. Why ? is there any issue with them when y try to save the invoice infosrmation ?
Hi and thanks. Tables are great for easy to use data and dashboards however I often find them a bit restrictive and I don't always like the automation (for example, if i add some data adjacent to the table I may or may not want to make this a part of the table, however Excel assumes I always want to make this data as part of a table) Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, hope you are well, doing some great stuff for the excel community. I use your protection video a lot, however, the part where you use the saveas UI, i would like the user to still use the saveas but force the xlsb format in the dialog, but im unable to achieve the with the 365 as it is not a pop up dialog anymore, please help as i see some users save the file as xls etc to gain access to copy my work. Thank you in advance.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi Randy, thanks for your videos, great work, i have a problem and I trying to solve it , will you support me in this regards? i am a buyer and I trying to create excel sheets for tracking if all the materials related to POs is well received in our warehouse in addition to track the invoices , the problem is there are multiple payment agreements and multiple delivers for the same order. so can you? Pease !
HI Hussam, thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm
Thank you for this great video. I am using tables all the time and gained some nice ideas. Thanks again.
Awesome Jan, that is great to hear. Thanks for your continued support
Great video Randy. I have a table that has dynamic columns. The table has 16 rows and never changes. Should I switch from LastRow to LastColumn?
Hi and thanks, yes you can use LastColumn within your VBA Code to accommodate the dynamic column numbers. Thank you for your Likes, Shares & Comments. It really helps.
Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed. Thank you for your continued support.
Thank you Randy. Would like to see your video on RegEx in VBA
Thank you so very much, It is a good idea and I have written it down to incorporate it into a future video.
I hope this helps and thanks so much.
Great job, thanks, do you have any work for future about converting number to text for difference languages, thanks again
Hi and thanks for your kind words. My AI Toolkit should be able to handle that conversion here bit.ly/AIToolpack_RandyShared
I hope this helps and thanks so much.
Thatnks for your great video leatning. i have a question. When you create your projects (invoices, sales ....etc) you do not use the table in your BDD for storing data, but y use the static classic tables. Why ? is there any issue with them when y try to save the invoice infosrmation ?
Hi and thanks. Tables are great for easy to use data and dashboards however I often find them a bit restrictive and I don't always like the automation (for example, if i add some data adjacent to the table I may or may not want to make this a part of the table, however Excel assumes I always want to make this data as part of a table)
Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, hope you are well, doing some great stuff for the excel community. I use your protection video a lot, however, the part where you use the saveas UI, i would like the user to still use the saveas but force the xlsb format in the dialog, but im unable to achieve the with the 365 as it is not a pop up dialog anymore, please help as i see some users save the file as xls etc to gain access to copy my work. Thank you in advance.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi Randy, thanks for your videos, great work, i have a problem and I trying to solve it , will you support me in this regards? i am a buyer and I trying to create excel sheets for tracking if all the materials related to POs is well received in our warehouse in addition to track the invoices , the problem is there are multiple payment agreements and multiple delivers for the same order. so can you? Pease !
HI Hussam, thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
Thanks so much.