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.
