vba - Apply (complex, preset) filter of one excel sheet to another -


i have question:

i need filter excel sheet based on (preset) filter excel sheet.

e.g. thought, might possible read out shown line numbers or data names in column a. , take these results make other sheet filter same rows.

background:

i need work on "public" excel sheet, several people use different tasks.

the sheet contains >8000 rows of data of need edit hundred.

we made copy of sheet , applied several complex sets of filters on different columns (to different sets of data concerning us). don't want put these different filters new time. therefore added column in copy sheet, contains numbers each set of data (e.g. rows of filter-set 1 contain "1" in column, etc.). easy access our data.

however, need work in public sheet, here can't add column our filters (for different reasons).

therefore question above: can filter excel table based on (preset) filter excel table.

what tried:

  • search internet --> no hits special case
  • search how obtain results of applied filter. i.e. information of excel, rows should show now, apply on other sheet --> no hits :(
  • go through each line of public sheet , if line in copied sheet our "filter set" column doesn't show "1", hide row in public sheet. --> takes ages if disable sheet screen updating. plus, need apply additional filtering on public sheet. extra: tried other way round: hide rows , show hundred need. here failed telling excel unhide rows(58,89,90,101,411,489, ...). though think must simple. can't syntax right :(

    on appreciated well, stumble across problem more often.

thank , time in advance.

all best

yanine.

based on understand want filter data based on value have in column right? if filter value constant can use in code filter column or if not can loop through filter value , use in code filter data. please share 1 example can beter understand problem.


Comments

Post a Comment

Popular posts from this blog

node.js - Node js - Trying to send POST request, but it is not loading javascript content -

i have been trying send post request website, , has not been loading full site. i guessing problem node js not loading javascript content, executing it. can see javascript in response, though never loads content javascript files producing in html. what mean is, doesn't execute javascript. how make node js code overcome this, , wait the full website load? have tried native code, , "request' module, both producing same errors. if helps, don't need native javascript. modules fine. some code have tried (request module): var options = { method: 'post', uri: 'https://url', formdata: { 'email': 'email', 'prize': '0', 'transactional': 'on' }, headers: { /* 'content-type': 'application/x-www-form-urlencoded' */ // set automatically } }; rp(options) .then(function (body) { console.log(body) }) .catch(function (err) { console.log(err) }); when fetch content...
Read more

javascript - Replicate keyboard event with html button -

i have tried few ways make happen. have javascript pinball game uses keyboard keys controls. converting application touch screen display. workaround, hoping overlay buttons when clicked simulate keyboard strokes. have done research , sounds should work. using jquery v3.2.1 here things have tried far... html element: <input type="button" class="coil"></input> $('.coil').trigger({type: 'keydown', which: 40, keycode: 40}); with this, not errors, nothing happens. var coilkey = $('body').keydown(function(e) { switch (e.keycode) { case 40: break;} }) $('.coil').click(coilkey); this 1 returns error in console... ((jquery.event.special[handleobj.origtype] || (intermediate value)).handle || handleobj.handler).apply not function below javascript game engine handles key listeners... addkeylistener: function (keyandlistener) { this.keylisteners.push(keyandlistener); }, // gi...
Read more

javascript - Web audio api 5.1 surround example not working in firefox -

i've been playing lott lately web audio api on both firefox , chrome. few days ago started experiment surround set. when trying surround audio in web audio api came notice example works fine in chrome v59 not in firefox v54. // create web audio api context var audioctx = new (window.audiocontext || window.webkitaudiocontext)(); audioctx.destination.channelinterpretation = 'discrete'; audioctx.destination.channelcountmode = 'explicit'; audioctx.destination.channelcount = 6; var oscillators = []; var merger = audioctx.createchannelmerger(6); console.log(audioctx.destination, merger); //merger.channelinterpretation = 'discrete'; //merger.channelcountmode = 'explicit'; //merger.channelcount = 6; var addoscilator = function(channel, frequency) { var oscillator = audioctx.createoscillator(); oscillator.frequency.value = frequency; // value in hertz oscillator.connect(merger,0,channel); oscillator.start(); oscillators.push(o...
Read more