excel - Populate list via a bi-Condition -

-

I'm interested in implementing something but I'm not sure it would be possible and would like to take it on.

This is my scenario:

I will have two verification cells, which will be shown as a list, from which I will select. This is my condition that I want to remember and remember my list from a database.

I have a list of agents, which has been thrown at B13: B23 and the next two, I have columns of data that assume that my data base looks like this 

  bcdx | Y Z Agent 1 1 | 1 | 0 Agent 2 0 | 1 | 0 Agent 3 0 | 1 | 1 agent 4 1 | 0 | 0

...

I want to populate a list named agent from column B, when I verify cell 1: x and verification cell 2: 1 I choose from. It should only show an agent in column X with 

  column: agent1 agent4

or 0 ...

I read somewhere Array formula but I do not know if this is convenient and I have unfortunately not any background in the macro :( But I know C ++ is quite easy with some conditional statement like this.

Advance Thanks,

This is possible. One way to contact this is to make a sub call you Listens to the respective agents whenever the target binds with their Worksheet_Change verification CELL1 or CELL2 -> Changes Verification

Then you have 3 paramenters srcRange, validationColumn and validationValue that throws every row of srcRange and checks If the sub-station would run with a run on the rownumber, the verification column is equal to the value idationValue then this agent output and set outputrow + 1

Put this VBA in your letter if: 

  Option Clear Private Sub Worksheet_Change (ByVal target as Ray H) Range dim dimension as integer set clock in the form of slow watchRange as the clock clock = Range = Me.Range ("H1, I1") 'Validation Cell' if there is no difference (target, watchrange) something If the value is not set then the verification value = Me.Range ("I1") is 0 with validation column = Me.Range ("H1") (.Value = "X") then validationColumn = 2 (.Value = "Y") then validationColumn = 3 then (.Value = "Z") then validationColumn = 4 end listAgents Me.Range ("B3: E6"), validationColumn, validationValue end then End Sub personal sub listAgents (ByRef srcRange As ray Range in the form of ByRal validationValue, byVal validationColumn as integer), dim dimension output as dim lines in the form of slow outputStart as boundary range = start.Start Me.Range ("H3") outputStart.CurrentRegion.Clear if validation Column = 0 then the MsgBox "Verification column can not be found" sub-end if left for each line in I = 0 srcRange .ows are (row.Cells (1, validationColumn) = validationValue) then outputStart (1 + i, 1) ) = Row.Cells (1, 1) I = i + 1 end then the next line End Sub

The inspection and it worked.


Comments

Post a Comment

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

-
I would like to capture all incoming HTTP packets on my machine. To do this, I am using SharpPcap which is a WinPcap The cover is. SharpPcap works very well, but it captures TCP packets and what it wants to do for me is a very low level. Does anyone know how can I easily get full HTTP requests / reactions from all these TCP packets? Thanks SharpPcap is already able to capture the packet in the same way That's what the virus does (just in the code instead of the GUI). And you can either either parse them directly or you can put them in the drive in the common .pcap file format. The steps to parse the capture are: Open a connection at any time Loop a while Or start capturing using an event callback Parsing the raw packet for the type you want If you are reading .PPP dump files In addition to calling you an offline capture reader is almost the same, there is no need to select an interface, and you can set the majority There is no need to do the modes. All st
Read more

jquery - SimpleModal Confirm fails to submit form -

-
I am trying to confirm jQuery to show yes / no confirmation when I submit a form. I had modified (in the last list) to capture and block form submissions. However, it only works with jQuery 1.2.6, a recent upgrade stops 1.3.2, if yes is clicked, then by submitting the form. But I can not understand what is wrong / inconsistent in my code now. Demo (which works in both versions of a simple window.href implementation). $ (document) .ready (function () {$ ('input.delete'). Click (function (e) {e.preventDefault (); var target = $ (e .target); Confirm ("Really delete this event?", Function () {target.click ()});});}); How about something like this? The idea of ​​catching clicks (and fire!) On the submitted event is not click event. $ (document) .ready (function () {$ ('# myForm'). Submit (function () {var f = this; Confirm (" Remove? ", Function () {$ (f). Submit ();}) Return; Return the initial session;}}}}; Hope That this is som
Read more

php - Multiple Select with Explode: only returns the word "Array" -

-
By using Wordpress I have created a multiple selection box so that users can select categories to exclude. When the page is initially loaded, I see my predefined default option. However, when I select a new value and I save ... I only see the word "Array" and have not chosen anything else? & lt; Class = "amultiple" id = "& lt; php echo $ value ['id'] ;? gt;" name = "& gt; php echo $ value ['id'] ;; gt; []" Multiple = "multiple" size = "8" & gt; & Lt ;? Php global option; Foreign currency ($ value as value $) {if (get_settings ($ value ['id']) === FALSE {$$ value ['id'] = $ value ['std']; } And {$$ value ['id'] = get_settings ($ value ['id']); }} $ Ranges = & amp; Amp; Categories ('type = post & orderbiz = name & amp; hide_empty = 1'); If ($ ranges) {$ ex_cat = implode (',', $ tt_cat_exclude); Forex Currency ($ range a
Read more