excel - Advanced.Filter VBA -

-

i have code far, sheet 2, how can alter code include multiple sheets this? complete newb here. :

sub extractuniquevalues()      sheet1.range("c:c").advancedfilter xlfiltercopy, , sheet4.range("c1"), true     sheet2.range("c:c").advancedfilter xlfiltercopy, , sheet4.range("c1"), true  end sub

you can that:

filter data in place:

sub extractuniquevalues()     dim wks excel.worksheet      each wks in excel.activeworkbook.worksheets         call wks.range("c:c").advancedfilter(xlfilteraction.xlfilterinplace, , , true)     next wks  end sub

filter data , paste them new worksheet: 

sub extractuniquevalues2()     dim wks excel.worksheet     dim wkssummary excel.worksheet     '----------------------------------------------------------------------------------      on error resume next     set wkssummary = excel.thisworkbook.worksheets("unique data")     on error goto 0      if wkssummary nothing         set wkssummary = excel.thisworkbook.worksheets.add         wkssummary.name = "unique data"     end if       'iterate through worksheets, skip [summary] worksheet.     each wks in excel.activeworkbook.worksheets          wkssummary              if wks.name <> .name                 if application.worksheetfunction.counta(wks.range("c:c"))                     call wks.range("c:c").advancedfilter(xlfiltercopy, , .cells(.cells(.rows.count, 1).end(xlup).row + 1, 1), true)                 end if             end if          end      next wks  end sub

unique data each worksheet printed in first column of new worksheet called unique data.

this method filters data each worksheet separately, if there example value a in sheet1 , value a in sheet2, there 2 entries a in result list.

note first value considered header , can duplicated in result list.


Comments

Post a Comment

Popular posts from this blog

yii2 - Yii 2 Running a Cron in the basic template -

-
i have seen instructions on running cron in advanced template, cant figure out how on basic template. have following controller in basic controllers folder. <?php namespace app\controllers; use yii\console\controller; /** * cron controller */ class croncontroller extends controller { public function actionindex() { echo "cron service runnning"; } public function actionmail($to) { echo "sending mail " . $to; } } i have navigated root of application , tried these comands yii cron php yii cron im getting unknown comand "cron" i know old question failed find actual answer this. if @ code yii exec file you'll notice requires /common/config/aliases.php file console/config/main.php. can naturally change these or copy on these advanced template. hope solves problem wanting same thing.
Read more

asp.net - 'System.Web.HttpContext' does not contain a definition for 'GetOwinContext' Mystery -

-
i realize question might seem trivial some, it's these types of things find myself fighting quite bit , want make sense of despite seeming losing battle in .net (for me anyway). so, if following: using system.web; ... applicationuser user = system.web.httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); that produces error in title , red getowincontext() , error cannot resolve symbol 'getowincontext()' however, if following (remove system.web in front of httpcontext ), works expected (or @ least no errors): using system.web; ... applicationuser user = httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); however, if (same line that's working using system.web commented out): //using system.web; ... applicationuser user = httpcontext.getowincontext().getusermana
Read more

php - How do you embed a video into a custom theme on WordPress? -

-
i'm using wordpress 4.2.3 , created custom theme use. when try embed youtube video (pasting http:// link content area), video shows in edit content area, when view site, shows text url instead. i tried sorts of things clear formatting, removing link, unchecking settings in writing area, etc. temporarily switched default wp theme , video shows up, i'm missing in template code, , can't figure out what. here code used outputting content in template. index.php <div class="video"> <?php $post_id = 26; $queried_post = get_post($post_id); echo $queried_post->post_content; ?> </div> thanks - appreciate it!
Read more