This is helpful. Is there a way that I can set a hyperlink to the cells which will link to the next cell? I tried to set a hyperlink but it goes away when I do the search.
Hello :), Can you help me with the below query please, I have a sheet which gets updated every day( can't disturb that main sheet), i want to auto-replicate the RAW sheet to a Duplicate sheet should get auto update and need to use the Search box in the duplicate sheet ,
Hi , Kindly use vlookup ad xlookup to generate auto update from the main page , after complete those updates, later use the search box where you are required .
@@techcachetamil hey, thank you for the reply... I've tryed the range table and used filter option with search box to replicate the data while u search.. Used LEFT and LEN to match the option in real time.. And used record macro to clear the Search fields for the next use.. It worked like a charm
Excellent your demo
❤❤❤❤
Sister kk successful thanks you
Thank you so much
Good your explain
Thanks and welcome
This is helpful. Is there a way that I can set a hyperlink to the cells which will link to the next cell? I tried to set a hyperlink but it goes away when I do the search.
Hi, You can use assign operator = to link one cell to another cell , use Vlookup or Xlookup
Hello :), Can you help me with the below query please, I have a sheet which gets updated every day( can't disturb that main sheet), i want to auto-replicate the RAW sheet to a Duplicate sheet should get auto update and need to use the Search box in the duplicate sheet ,
Hi , Kindly use vlookup ad xlookup to generate auto update from the main page , after complete those updates, later use the search box where you are required .
@@techcachetamil hey, thank you for the reply... I've tryed the range table and used filter option with search box to replicate the data while u search.. Used LEFT and LEN to match the option in real time.. And used record macro to clear the Search fields for the next use.. It worked like a charm
Nice to hear. Thank you👍@@rocketranjith8942
Neenge sonnathu success aahina but 2nd chepter colure change panre athude codings le error aahuthu