Hi Ajay need your help. I want to send a mail which consists of individual performance report in pivit format.Through outlook email.I have a Performance data, automatically pivot should form and send respect report to their respective email IDs.
Hi Sir, I have a worksheet of Vendor invoice details including their payment status. In payment status i want to set a condition for controlling the comments. I want to keep the comments if the cell value in payment status column is either “Rejected” or “Query”. Except both these any other cell value the comment of that active cell should be cleared. Please help me to create this VBA.
Hi Sir. Thank you very much for the amazing videos as usual. I keep on writing to you a lot and thanks a lot for responding back with a solution. I am facing some issues with a coding and thought of sharing it with you. For example I have 5 members in my time and they login at different time every morning.I have saved a file on the shared drive and I want their system login time to be captured automatically everyday. I tried to write the code and placed it on the opening event of the workbook using NOW function. But every time the file opens the time captured earlier for the previous users also gets refreshed. Could you please help with this so that it captures the exact login time for each user every day. Or if you could advise is there any other way to do this.
I think, your file is one and it is opened by every one.. So, you program your code in a way that it triggers the email to you with the time... Or you Keep user name and time in seperate workbook.... So, if I open file five times in day, in other file it should Keep my record five times... Every time new time should be inserted and it should not overwrite.... I will talk on this great question.... TX Alam
it is very delightful for us to teacher like you, thanks a ton sir for all your valuable videos... :)
VERY ENLIGHTENING!
hi sir if write a code on module in particular sheet, does it is applicable to the other sheets also
Nope
Hello Sir,
How can we use event in personal macro ? I should not want to save permanent file. It should run with all new workbook/worksheet.
Create add in...
Please describe in lecture.
Hi Ajay need your help. I want to send a mail which consists of individual performance report in pivit format.Through outlook email.I have a Performance data, automatically pivot should form and send respect report to their respective email IDs.
have external value load in A1, its auto update, whenever the value change itself, need msg, how to write, pls
Hi Sir, I have a worksheet of Vendor invoice details including their payment status. In payment status i want to set a condition for controlling the comments. I want to keep the comments if the cell value in payment status column is either “Rejected” or “Query”. Except both these any other cell value the comment of that active cell should be cleared. Please help me to create this VBA.
Use if statements
Plz mKe evnt series in hindi
Hi Sir. Thank you very much for the amazing videos as usual. I keep on writing to you a lot and thanks a lot for responding back with a solution. I am facing some issues with a coding and thought of sharing it with you. For example I have 5 members in my time and they login at different time every morning.I have saved a file on the shared drive and I want their system login time to be captured automatically everyday. I tried to write the code and placed it on the opening event of the workbook using NOW function. But every time the file opens the time captured earlier for the previous users also gets refreshed. Could you please help with this so that it captures the exact login time for each user every day. Or if you could advise is there any other way to do this.
I think, your file is one and it is opened by every one.. So, you program your code in a way that it triggers the email to you with the time... Or you Keep user name and time in seperate workbook.... So, if I open file five times in day, in other file it should Keep my record five times... Every time new time should be inserted and it should not overwrite.... I will talk on this great question.... TX Alam
Video 379 is uploaded ...