hello
I have this file and put the result in sheet "result" the search is based on column a across multiple sheets if is possible do that without button when run the macro like worksheet change event
thanks in advance
hello
I have this file and put the result in sheet "result" the search is based on column a across multiple sheets if is possible do that without button when run the macro like worksheet change event
thanks in advance
Hello,
Attached is a formula based solution in your test file
Hope this will help
great work ! just I would some updating please if b1 ="" or the value nothing is existed , then the range b2: b7 should be empty , currently show error #N/H , could you fix it?
Glad this could help you out ...
Attached is your test file with the requested modification
Hope this will help
well done ! thanks so much for your assistance
well done ! thanks so much for your assistance
Thanks a lot for your Thanks !!!
AND for the Like
Don’t have an account yet? Register yourself now and be a part of our community!