Hi guys, I hope you guys have a nice day. I need your help.
Problem: I want to get last non-zero value on another workbook (E10:E40)
Step1)Press this button in 1st workbook 1.PNG
step2)it will open 2nd workbook
2.PNG
and copy last non-zero value on rank E10:E40 to 1st workbook
this is my vba code in 1st workbook for copy last non-zero value but it doesnt work , can you guys figure it out, please.
Capture.PNG
Bookmarks