LinkBack URL
About LinkBacks
Attached is the sheet with issue.
Need a vba code to check the status and based on rules calculate service years
Attached is the sheet with issue.
Last edited by baba_excel; 12-18-2012 at 05:03 PM.
please do let me know if such code could be done any suggestion steps would be appreciated
Last edited by baba_excel; 11-28-2012 at 08:53 PM.
You might take a few minutes to read the forum rules -- in particular, the part about getting your questions answered quickly.
Entia non sunt multiplicanda sine necessitate
thx shg will be keeping these things in mind...good that you highlight it
Last edited by baba_excel; 11-28-2012 at 08:49 PM. Reason: Meaning full title
....and in addition see the rule about meaningful titles. Please change it.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thx Richard.....learning all the way ...not sure why not title is displaying for each post
hi again ....its been long now however it did not get a workaround from my problem as attached.......but would it be possible for group to have a look at the same and let me know if what is required is possible using excel vba also would appreciate if it is just the key words or directions for the same would help in proceeding further.
Not expecting the solution but direction suggestion would help me working for the same
vba_code_3.xlsm is attached in post#1, this is updated where in checking step by step the code was running with msg box displaying 2 ans but at my home system it is giving errors first one being "Invalid qualifier".
Any suggestions or updates are much appreciated.
vba_code_3.xlsm is attached in post#1, this is updated where in checking step by step the code was running with msg box displaying 2 ans but at my home system it is giving errors first one being "Invalid qualifier".
Any suggestions or updates are much appreciated.
Greetings .....
was able to overcome the error ...needed to do x = instead x.
Please see the update ....also moving with same is there a way to check the previous value for cell c.
i.e in if condition c is checked for LOA now if it is true and >1 then prior ACT period gets added.
Overall goal is to insert data into sheets from database which may have multiple statuses for same hence think need to update the code me trying the same but inputs would be much appreciated
Please Login or Register to view this content.
Greetings .....
was able to overcome the error ...needed to do x = instead x.
Please see the update ....also moving with same is there a way to check the previous value for cell c.
i.e in if condition c is checked for LOA now if it is true and >1 then prior ACT period gets added.
Overall goal is to insert data into sheets from database which may have multiple statuses for same hence think need to update the code me trying the same but inputs would be much appreciated
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks